Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Search For:

Type: Posts; User: Epidemic

Page 1 of 3 1 2 3

Search For: Search took 0.01 seconds.

  1. Replies
    3
    Views
    102

    Re: Open file error

    So the On Error Goto is not capable of handling this? I need to know so that I don't fall down this path again.
  2. Replies
    3
    Views
    102

    Open file error

    For x = 1 to 10
    On Error GoTo Skip_Missing_Data_type
    Set WB = Workbooks.Open(RawWBPth(x)) ' Opens file from calculated location Raw Path
    ' bunch of code
    ' bunch of code...
  3. Replies
    1
    Views
    140

    Subscript error

    Public RawWBName As String ' Name of active raw report.
    Public KPIReptName As String ' Kpi report name is the name of this workbook.
    Public RawWBPth(1 To 5) As String ' Path and...
  4. Re: Code jumps out for some reason to previous Subroutine.

    oops,

    I tried your code it still is a not able to run unless I have the sheet active.



    With Sheets("magicindex")
    FirstRow = .Row
    LastRow = .Range("A" & .Rows.Count).End(xlUp).Row...
  5. Re: Code jumps out for some reason to previous Subroutine.

    Thank you. I am still not sure why the first method did not work but this one does work. I make some work arounds where I activated the sheets and jump around. I will go back to try and...
  6. Re: Code jumps out for some reason to previous Subroutine.

    Ok this works sorta, I am not sure why but it appears that the sheet has to be active to function. I thought the with sheets statements should take care of that. I get a 1004 error until I make...
  7. Code jumps out for some reason to previous Subroutine.

    I have been trying to figure out why my macro jumps to the former subroutine when I perform this line of code.

    Sheets("MagicIndex").Selection.Copy
    ...
  8. Replies
    3
    Views
    363

    Re: Change the x axes on all charts.

    Ok This is my Newest code. I don't know how to do this if my sheet is inactive but If the macro is launched on my active sheet and I "select" everything I need to, it works. I don't particularly...
  9. Replies
    3
    Views
    363

    Re: Change the x axes on all charts.

    BTW this is the recorded macro



    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).CategoryType = xlCategoryScale
    Selection.TickLabels.NumberFormat = "m/d H"

    ...
  10. Replies
    3
    Views
    363

    Change the x axes on all charts.

    When the user changes they source data from days to hours I need to have the macro make change the axes to reflect the change in some 12 separate graphs.

    Below is my entire code thus far. Of...
  11. Re: Why cant I directly set Wrap on a range of cells?

    Thank you,

    It drives me nuts because I can not spot errors like these. I get hung up on these details all the time.


    My programs are awesome, My programming sucks.
  12. Why cant I directly set Wrap on a range of cells?

    I would like to simply reference this range of cells and change one formatting attribute.



    Sheets("flaggedSite report").Range(Cells(RowV, 2), Cells(RowV, 6)).WrapText = True



    I get a...
  13. Re: how can I make a range of cells the same on an inactive sheet using cells functio

    Very intersting. I will play with these that copy resize thing sounds like what I need.

    Although I think alketraz's Idea is good as well. Thank your folks for your assist I would be coding...
  14. how can I make a range of cells the same on an inactive sheet using cells function.

    This does not work
    Sheets("flaggedSite report").Cells(lastrow + 1, 1) = Sheets("GS 1").Range("D4:H10")

    This Does work
    Sheets("flaggedSite report").Cells(lastrow + 1, 1) = Sheets("GS...
  15. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Feel like I am talking to myself. But I did figure out what was wrong from post 2 I had to reverse the logic for the if to be true.
  16. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Ok fail the =sum(if statement works but not the STDev(if
  17. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Ok I have progressed a little but not the way I wanted.

    I found that I can do a logical test in another column and use that to feed my statistics formula.

    In column "I" I made a test to test...
  18. How do I perform statistical analysis on Day of the week and for the last X weeks.

    I was working with formula array but when I put the And in all hell broke loose.

    I have named ranges
    Graphdaterange has all of my dates
    GS1 has the value I want to analyze

    Ultimately I want...
  19. Re: Error when attempting to change font color on secondary axis using VBA.

    Well my solution although not all that graceful was to create a template and I call that template.



    ActiveSheet.ChartObjects("Chart 8").Activate
    ActiveChart.ApplyChartTemplate...
  20. Re: Error when attempting to change font color on secondary axis using VBA.

    My Bad, I am working with MS excel 2013
  21. Error when attempting to change font color on secondary axis using VBA.

    ActiveSheet.ChartObjects("Chart 8").Activate
    ActiveChart.FullSeriesCollection(2).Select
    ActiveChart.FullSeriesCollection(2).AxisGroup = 2
    ActiveSheet.ChartObjects("Chart 8").Activate
    ...
  22. Re: how can I add 0 to a date value that is presenting as text.

    Sub ConvertToNumbers()
    With ActiveSheet.UsedRange
    Firstrow = .Row
    lastrow = .SpecialCells(11).Row 'selects Last row number
    End With
    ...
  23. how can I add 0 to a date value that is presenting as text.

    I have a column with several hundred thousand date values but they are in text format.

    Usually I would copy zero and paste special values add. This instantly converts look alike text date to...
  24. Replies
    2
    Views
    402

    Re: Open an excel file as a temporary name

    Thanks I chose to do a save as. It is slower but it works.
  25. Replies
    2
    Views
    402

    Open an excel file as a temporary name

    Is there a way to open an excel file with a formula friendly temporary name.

    The users of my spreadsheet will need to open up many different file types and dates to feed my interface.

    the...
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno