satyen
05-18-2008, 02:34 AM
Hi
Im using this to find an empty column in my worksheet,
colTmp = .Range(.Cells(1, 1), .Cells(1, 1).End(xlToRight)).Columns.Count + 1
But it finds the first empty cell in the column and thinks the whole column is empty, which is not the case.
Can anyone help me to ammend the code to ensure it looks at the whole column?
Many thanks
Im using this to find an empty column in my worksheet,
colTmp = .Range(.Cells(1, 1), .Cells(1, 1).End(xlToRight)).Columns.Count + 1
But it finds the first empty cell in the column and thinks the whole column is empty, which is not the case.
Can anyone help me to ammend the code to ensure it looks at the whole column?
Many thanks