how can i reference every third column in a row?

  • Thread starter Thread starter garyusenet
  • Start date Start date
G

garyusenet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find 2 values & return row number 1
tranposing every third cell in a row to a column 2
Mailing address block: sorting 1 row to columns 1
Macro to insert a line when a value changes in a range 1
moving rows to another sheet 3
Moving a bunch of data 1
Excel Help to copy information from one row at a time to another sheet 1
insert a line 1

Back
Top