Hi all,

Sorry for the n00b post. I have searched around for the answer to this and couldn't find what I was looking for.

In Excel 2007 & 2010, you can click the "Format as Table" button on the Home ribbon and Excel automagically figures out the range of cells that contain the table data you want to format.

How can I do this in VB? I've seen some really hokey solutions using loops, but that seems like a terrible way to go... in pseudocode, these solutions look like:

Start at A1 and check each value column-by-column until you find a NULL. Then go back one column and that's your column range boundary.

Start at A1 and check each value row-by-row until you find a NULL. Then go up one row and that's your row range boundary.

Your table range is A1 : LastCol, LastRow


I can't believe that this is the best way to solve this...

__________________
Take care,

Nik

Hi Nik

Have you tried UsedRange. It should work for you

Regards
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)