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
Related:
- Naming range in a macro
- Spell number in excel without macro - Guide
- Macros in excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
- Apple airtag range - Guide
- Excel macro to create new sheet based on value in cells - Guide
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
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