Just try this....
Worksheets("RAW").Range("A4701:CE4900").Copy _
Destination:=Worksheets("ExecServices").Range("A" & iNextRow&":CE" &
iNextRow)
> Date: Thu, 23 Apr 2009 10:54:34 -0700
> Subject: $$Excel-Macros$$ Macro Help
> From: dustin.ho...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Okay guys, I can't get this one. I've been trying for hours to make
> this work and I am missing something small.
>
> Here's the deal: This is part of a larger set of macros I am writing.
> This snippet shows that I am looking for the next available row and
> then copying from a worksheet called RAW and then pasting that range
> into the next available row on the ExecServices worksheet.
>
>
> Worksheets("RAW").Range("A4701:CE4900").Copy _
> Destination:=Worksheets("ExecServices").Range("A" & iNextRow)
>
> Note that "iNextRow" is a variable for the next available row.
>
> the above code works great. What I need, is to NOT have static cell
> references like ***Range("A4701:CE4900")****. I want to be able to
> specify those ranges with variables. So what I want will (I think)
> look something like this:
>
> Worksheets("RAW").Range("A4701:CE4900").Copy _
> Destination:=Worksheets("ExecServices").Range("A" & iNextRow:"CE" &
> iNextRow)
>
> but this returns an error any way I try to do it.
>
> I love this group and I have a lot of faith in you guys already =)
> Help is very much appreciated!!
>
> also, as a side note... is there a way to be notified when your
> discussion post is replied to?
>
> Dustin
>
>
>
> >
_________________________________________________________________
How fun is this? IMing with Windows Live Messenger just got better.
http://www.microsoft.com/india/windows/windowslive/messenger.aspx
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
