Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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
    205

    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...
  2. Replies
    3
    Views
    205

    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"

    ...
  3. Replies
    3
    Views
    205

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

    My Bad, I am working with MS excel 2013
  14. 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
    ...
  15. 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
    ...
  16. 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...
  17. Replies
    2
    Views
    242

    Re: Open an excel file as a temporary name

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

    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...
  19. 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
    ' ...
  20. 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...
  21. 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...
  22. Re: Copy and paste using .range(cells(1,1), cells(1,7))

    Ok I thought it worked but it appears as if the copy part fails if I am not on the sheet "Scratch_Sheet"

    So back to my question, What is wrong with coping data from another sheet? is there a...
  23. Re: Copy and paste using .range(cells(1,1), cells(1,7))

    Sheets("Scratch_Sheet").Range(Cells(1, 1), Cells(1, 7)).Copy
    Sheets("Summary").Cells(1, 1).PasteSpecial


    Seems like there are many ways to skin a cat. Looking around the varying solutions on...
  24. Copy and paste using .range(cells(1,1), cells(1,7))

    Sheets("Scratch_Sheet").Range(Cells(1, 1), Cells(1, 7)).Copy
    Sheets("Summary").Range(Cells(1, 1), Cells(1, 7)).Paste


    Ok what is inherently wrong with this? I am trying to copy a range of...
  25. Replies
    4
    Views
    798

    Re: Subscript out of range excel 2007

    That is funny because the code was written years ago and it is what I got from a modified recorded macro. I guess they changed that for some reason.

    oh well, thanks.
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno