Naming range in a macro [Closed]

- - Latest reply: mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
- May 6, 2009 at 01:21 AM
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
See more 

1 reply

Best answer
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
209
2
Thank you
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








Say "Thank you" 2

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

CCM 5735 users have said thank you to us this month