VBA -Excel - How to replace a column letter to a column index in a Range function

Asked Sep 27 '22 at 13:12

Active Sep 27 '22 at 13:13

Viewed 17 times

I need to replace code Sheet5.Range("N2:N24").Value = Sheet1.Range("B9") with something like Sheet5.Range(Columns(14).Select & "2:" & Columns(14).Select & "24").Value = Sheet1.Range("B9")

but it gives an error. Basically I would like to replace the column letter with the index of the column. How is the syntax?

Many thanks, Electra

edited Sep 27 '22 at 13:13

BigBen

46,229
7
24
40

asked Sep 27 '22 at 13:12

Electra

1

Use `Cells`, which accepts the column index as the second parameter. – BigBen Sep 27 '22 at 13:13
2

`Sheet5.Range(Sheet5.Cells(2, 14),Sheet5.Cells(24,14)).Value` – Warcupine Sep 27 '22 at 13:14

VBA -Excel - How to replace a column letter to a column index in a Range function

0 Answers0