Naming range in a macro [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I am tyring to name a range say a14:d14 (working_cap_formula) and then copy of past into range a15:d15 (working_cap_paste).

I have set up a macro to do the sopy and paste process but would like to name the range in the macro to ensure if rows are deleted or inserted above row 14 then the macro will still find the ranges to copy from (working_cap_formula) and paste to working_cap_paste).

thanks

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
Suppose your data is in Range A3 to onward so using this formula in

=OFFSET(Sheet1!$A$3,0,0,COUNT(Sheet2!$A:$A),1) or you can use countA function if don't have numerics ..... this will work out dynamically








2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!