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
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
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
Related:
- Naming range in a macro
- Spell number in excel without macro - Guide
- Apple airtag range - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macros in excel download free - Download - Spreadsheets
- How to count names in excel - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 6, 2009 at 01:21 AM
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
=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