Column.

  • Thread starter Thread starter TJF
  • Start date Start date
T

TJF

Hello,

I need use something like:

new = range("A" + x & 2).value

when x = 2 then I need this result

new = range("B" & 2).value

Is this somehow possible?

Thanks Tom
 
Use the Cells object instead

new = Cells(2, 1 + x).Value
 
You must log in or register to reply here.

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

Transfer array element offset value to a matched value 3
VBA set thick borders around non empty cells in range 0
Conflict 8
Range passed to a function - trying to just move through the range 4
Excel VBA help: Text file formatting 19
Excel VBA 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Matching Columns 2

Back
Top