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. 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...
  2. 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...
  3. 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...
  4. 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
    ...
  5. Replies
    3
    Views
    344

    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...
  6. Replies
    3
    Views
    344

    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"

    ...
  7. Replies
    3
    Views
    344

    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...
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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
  14. 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...
  15. 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...
  16. 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...
  17. Re: Error when attempting to change font color on secondary axis using VBA.

    My Bad, I am working with MS excel 2013
  18. 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
    ...
  19. 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
    ...
  20. 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...
  21. Replies
    2
    Views
    387

    Re: Open an excel file as a temporary name

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

    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...
  23. Re: Pastespecial method of range class fails after upgrade to 2013 from 2007

    I populated the row with 1


    Windows(ReportName).Activate
    Sheets(LAFPivotSheet).Select

    Range("d2").Select
    Selection.End(xlToRight).Select
    ' ...
  24. Pastespecial method of range class fails after upgrade to 2013 from 2007

    I recently upgraded from office 2007 to 2013 and I am experiencing a couple of problems for now lets address this one (Pastespecial method of range class failed)



    Windows(ReportName).Activate...
  25. Re: Copy and paste using .range(cells(1,1), cells(1,7))

    Thank you I will give it a try.

    my solution is less elegant. I found that if I changed sheets to the copy from sheet it worked fine.

    I just don't like the fact I had to do it. It is not...
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno