You guys are awesome. Solved now, since you pointed out there is a
second syntax option for specifying a range.
Also, Paul. Thanks for that tip about the emails! I agree, as well.
I've learned most, if not all, of my VBA from here. I've been at it
for about a week so far. =) So,... experience away, my friends! lol.
On Apr 24, 7:31 am, Paul Schreiner <schreiner_p...@att.net> wrote:
> Dustin,
> it looks like you've had several replies to your question.
> I tested it, and it looks like Habeeb's answer works just fine
> (except for needing a couple of spaces:
> Worksheets("RAW").Range("A3:CE4900").Copy _
> Destination:=Worksheets("ExecServices").Range("A" _
> & iNextRow & ":CE" & iNextRow)
>
> In answer to your second question:
> "is there a way to be notified when your discussion post is replied to?"
>
> The answer is in your own profile setup.
> You need to go to "My Accounts"
> then "Manage Subscriptions"
> You need to set the "Subscription type" to Email.
> (Abridged email means you get it weekly)
> Keepin mind though that it's an all-or-nothing setting.
> you not only get responses to YOUR discussion, but everyone else's too...
> which is a GOOD thing..
> We learn by "experiencing". You can learn a lot by looking at what other
> people
> are "experiencing"!!!
>
> Paul
>
> ________________________________
> From: Dustin <dustin.ho...@gmail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> Sent: Thursday, April 23, 2009 1:54:34 PM
> Subject: $$Excel-Macros$$ Macro Help
>
> 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
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
