Column Letter from number

[leelee23]

Hi all,

I am trying to make a certain range have their cells go blank, but it could vary for some situations.

The data I may need to reset is:

J20:J78
M20:M78
P20:P78
.. continuing with skipping 2 columns all the way to..
BO20:BO78

This is what I currently have:

Please Login or Register  to view this content.

I think I need to convert the c to a column letter but I'm not sure how. Please advise.

Thanks,

Lee

[antoka05]

Try with this code:

Please Login or Register  to view this content.

But if you need to start from column 'J' plese set the first line so:

Please Login or Register  to view this content.

Regards,
Antonio

[boylejob]

You might try this. This clears the content of rows 20 thru 78 starting at J and going through BO. It is fairly "hard" coded, but could easily be modified based on variables.

Please Login or Register  to view this content.

[leelee23]

Thanks for your input... work's great