Search:

Type: Posts; User: Thralni

Search: Search took 0.03 seconds.

  1. MsOf10 Re: VBA Excel: Problem with WorksheetFunction.Large?

    Wow. I can't believe the answer would be that simple... Didn't even occur to me that that might be the problem! I changed it to double, and everything works great again. Thanks for helping!
  2. MsOf10 Re: VBA Excel: Problem with WorksheetFunction.Large?

    Is there a specific reasong that declaring them at the lowest level is the best option? I pretty much need to use all these variables throughout all subs, so I don't think I have much choice, do I?
    ...
  3. MsOf10 [RESOLVED] VBA Excel: Problem with WorksheetFunction.Large?

    Hey guys,

    I'm having a problem of whgich I have no idea how it came into being. It's about this bit of code:


    Sub GrootsteWaarden()

    Row = 3 'Begin bij rij 3
    RowEnd = 14 'Eindig bij...
  4. Replies
    4
    Views
    10,756

    MsOf10 Re: VBA: Pastespecial error 1004

    Never mind, I solved the problem by using this:


    Worksheets(WorksheetSource).Activate
    Range("B1" & ":" & CellStringOutput).Copy Destination:=Worksheets(WorksheetOutput).Range("A1")
    ...
  5. Replies
    4
    Views
    10,756

    MsOf10 Re: VBA: Pastespecial error 1004

    Hack: thanks for the welcome and suggestion! Sadly, it didn't work, still the same error :(

    Pete: Aaah, I see... Would you know an alternative method? The idea is that a whole set of data gets cut...
  6. Replies
    4
    Views
    10,756

    MsOf10 [RESOLVED] VBA: Pastespecial error 1004

    Hey guys,

    I'm trying to get VBA to copy and paste a range of cells from one sheet to another, but I always get an error 1004 at the Pastespecial line, saying that it failed to do the pastespecial....
Results 1 to 6 of 6



Click Here to Expand Forum to Full Width