Naming range in a macro

Closed
kingsley - May 4, 2009 at 05:16 AM
mubashir aziz Posts 190 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

1 response

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