MAcro to select number of colums
Closed
crisaldana123
-
Sep 28, 2009 at 10:19 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 28, 2009 at 09:24 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 28, 2009 at 09:24 PM
Related:
- MAcro to select number of colums
- Vba select case like - Guide
- How to select at the rate in laptop - Guide
- To create a network bridge you must select at least two lan - Linksys Forum
- Excel online macro - Guide
- Macro for number to words in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 28, 2009 at 09:24 PM
Sep 28, 2009 at 09:24 PM
The question needs rephrasing. I do not know what you want.
=column(a1)gives 1
=column (B1) gisves 2
=column(c1) gives 3 etc
if you want the last column number in the data
in vba
j gives the last column of data
study the difference between column(singular) and columns(plural) in help.
=column(a1)gives 1
=column (B1) gisves 2
=column(c1) gives 3 etc
if you want the last column number in the data
in vba
dim j as integer
j=range("A1").end(xltoright).column
j gives the last column of data
study the difference between column(singular) and columns(plural) in help.
