How do I determine the table range for a table with varying number of columns. I will always have a set number of rows, but the number of columns will vary. The following code creates my columns.
I will always have 9 rows, but I do not know how many columns. I would like to figure out the range.
Please Login or Register to view this content.
Last edited by kmoore; 07-20-2011 at 03:56 PM.
Why bother? You have Excel 2007 use the Format as Table feature
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I would like it to happen automatically once the user clicks a button. I do not know how to do it if the number of columns can change each time the table is created.
Look in the VBA Help at CurrentRegion
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns.
Last edited by royUK; 07-20-2011 at 02:39 PM.
Worked perfectly. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks