View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] louisamarkham@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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