O ogg13 Registered User. Local time Today, 04:50 Joined Jan 30, 2007 Messages 49 Feb 2, 2007 #1 Is there a cell range option that basically equates to 'all data in the worksheet that isnt blank'? IE instead of A1:N7, is there something that states "all populated cells:all populated cells"?
Is there a cell range option that basically equates to 'all data in the worksheet that isnt blank'? IE instead of A1:N7, is there something that states "all populated cells:all populated cells"?
Vader Registered User. Local time Today, 11:50 Joined Jan 18, 2007 Messages 16 Feb 2, 2007 #2 Hello ogg13! You can use VBA Sub PopulatedCells() ActiveSheet.UsedRange.Select 'here is what you want to do with your 'current selection End Sub
Hello ogg13! You can use VBA Sub PopulatedCells() ActiveSheet.UsedRange.Select 'here is what you want to do with your 'current selection End Sub
O ogg13 Registered User. Local time Today, 04:50 Joined Jan 30, 2007 Messages 49 Feb 2, 2007 #3 Im actually importing the data from access, so im not sure if that command would work, but its a start, so thank you 8)
Im actually importing the data from access, so im not sure if that command would work, but its a start, so thank you 8)
