Hi,
I have a variable called LastCol which contains the number 43.
I would like to clear out the contents associated with this column.
The following does not work:
I had earlier used this variable to populate the content in that column row by row (the below is an example):
How do I clear out a column if the column is represented by a variable? Thanks.
-Eileen
I have a variable called LastCol which contains the number 43.
I would like to clear out the contents associated with this column.
The following does not work:
Code:
Columns("LastCol:LastCol").Select
Selection.ClearContents
I had earlier used this variable to populate the content in that column row by row (the below is an example):
Code:
Cells(Counter, LastCol).Value = "FALSE"
How do I clear out a column if the column is represented by a variable? Thanks.
-Eileen