how do i use vba to select all columns on a spreadsheet that contain data.

how do i use vba to select all columns on a spreadsheet that contain data? All data columns are next to each other but i
do not necessarily know how many columns of data there are.
Also the first column of data is column A

many thanks in advance

pablowilks,

I wouldn't recommend just selecting them. Generally you don't need to select a range in order to perform an operation on it, but seeing as there are no additional details here you go

Please Login or Register  to view this content.