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

    Re: Open an excel file as a temporary name

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

    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...
  5. 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
    ' ...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. Replies
    4
    Views
    637

    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.
  12. Replies
    4
    Views
    637

    Re: Subscript out of range excel 2007

    Ok what did you change and why?
  13. Replies
    4
    Views
    637

    Subscript out of range excel 2007

    what is inherently wrong with this code?


    rowcount = 561
    A = 0
    Cell(A) = 115,1 'cell is an array containing many text strings. 0 is the first one.

    Set tst = Range("a1:a" &...
  14. Re: VBA pivot table type mismatch error when using the Cells object

    thanks I will try it and get back to you.

    Dude this is really funny trying to type with double vision.

    I just had work done on my eye after weekend auto work and subsequent eye work to remove...
  15. VBA pivot table type mismatch error when using the Cells object

    My only question is what do I have to do to get this to work.

    When rws = 65535 it works
    when rws > 65535 it fails. with a "run time error 13 type mismatch error."


    rws = 67000 right now
    clmn...
  16. Replies
    8
    Views
    14,028

    Re: Disable Pivot Table Refresh

    Set pt = ActiveSheet.PivotTables("PivotTable1")

    pt.ManualUpdate = True

    pt.ManualUpdate = False


    sorry wrong answer. I did not read the question properly
  17. Replies
    4
    Views
    1,690

    Re: OnTime Doesn't Fire When Computer Locked

    I do not think it is shared.

    it is a workbook on my hard drive that I launch every morning...

    nope no one is sharing it. Standard xls that runs if I disable the splash screen when locked but...
  18. Replies
    4
    Views
    1,690

    Re: OnTime Doesn't Fire When Computer Locked

    well by locking itself I mean when the screen saver password kicks in requiring the user to ctrl alt delete use password to unlock. the IT security policy uses this to secure terminals when people...
  19. Replies
    4
    Views
    1,690

    OnTime Doesn't Fire When Computer Locked

    I have a splash screen which allows the user to interrupt the start of my macro. my machine is forced by IT to lock itself after 30 minutes. While in locked mode the splash screen starts but the...
  20. Re: Convert Sheet In Another Workbook To Values Only

    wow thanks guys.

    I appreciate all your help and your bearing with my ignorant questions!

    I love this site.
  21. Replies
    4
    Views
    1,931

    Re: Spreadsheet Has Grown Exponentionally (for No Apparent Reason)

    actually I have simply copied all spread sheets and all code to new workbook and saved it and poof all is well with the world.

    the original sheet was created in office 2003 and I am working in...
  22. Replies
    4
    Views
    1,931

    File Has Grown In Size Exponentially

    I have a spread sheet with a macro attached to it, approximately 500 lines of code and 3 sheets approximately 30 rows by 30 columns.

    it recently shot up from 130 KB to 15,000KB. Do I need to...
  23. Re: Convert Sheet In Another Workbook To Values Only

    thanks man you are the bomb. i will try it.* Auto Merged Post Until 24 Hrs Passes;*can you explain why my code would not work. I simpy do not understand what is wrong with PvtDest.Cells.Select ...
  24. Re: Copy Paste Special To Remote Location.

    PvtDest is the remote sheet.

    I am running the macro from an interface workbook.

    I will call that update.xls

    I want to copy/paste special values to the same sheet my pivot table workbook...
  25. Convert Sheet In Another Workbook To Values Only

    I am trying to be a good programmer and not do a whole bunch of activate workbooks and worksheets blah blah blah. So I am 99% complete with my subroutine and stuck on 3 lines. I need to copy my...
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno