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

One way

Range("C" & i & ",E" & i & ",G" & i & ",I" & i & ",K" & i).Select

where i has your row number

Tim

<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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
>

Thanks a ton!!!!!

M


Tim Williams wrote:
> One way
>
> Range("C" & i & ",E" & i & ",G" & i & ",I" & i & ",K" & i).Select
>
> where i has your row number
>
> Tim
>
> <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> >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
> >