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
- Excel online macro - Guide
- How to increase wifi range from router settings - Guide
- Excel run macro on open - Guide
- Count names in excel - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. - Excel Forum
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