I want to copy the contents of every third column in a row.

I don't know how to reference every third column in a row without
naming each individual column, can someone tell me please?

i'm writing a macro as there are thousands of columns in this
spreadsheet.

Thanks,

Gary.

In essence what i'm actually asking is..

how can i copy every nth column to a string?

Thanks,
Gary.

How about

for i=1 to256 step n
activecell=activecell & cells(row,i)
next i

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In essence what i'm actually asking is..
>
> how can i copy every nth column to a string?
>
> Thanks,
> Gary.
>