Question on how to reference multiple cells in VBA
I am trying to select cells in a row that are not contiguous. Example
in row 15 i want select C, E, J, I, and K. I used the record macro
function to get
Range("C15,E15,G15,I15,K15").Select
but it will not always be row 15. I am adding rows to a spreadsheet via
a custom written macro and I am trying to select the different cells to
format them.
Thank you for any help,
Louis Markham
|