how can i reference every third column in a row?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

garyusenet@myway.com - 28 Jul 2006 09:40 GMT

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.

Reply to this Message

garyusenet@myway.com - 28 Jul 2006 09:54 GMT

In essence what i'm actually asking is..

how can i copy every nth column to a string?

Thanks,
Gary.

Reply to this Message

PY & Associates - 28 Jul 2006 10:05 GMT

How about

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

> In essence what i'm actually asking is..
>
> how can i copy every nth column to a string?
>
> Thanks,
> Gary.

Reply to this Message

Rate this thread: