Excel vba - Easy Range question

[markozzz]

Hi,
I couldnt figure this out..

In this sentence:

...Sheets("Sheet1").Range("G:J"), 4, False)

in .Range("G:J") i would like "G" to be a variable. Like .Range("(Var),J").. But that obviously doesnt work.

Help please?

Rgds,
Markozzz

 

[SkipVought]

Hi,

Take a look at the Cells property of range...

Sheets("Sheet1").Range("G:J")
iCol1 = Cells(1, "G").column
iCol2 = Cells(1, "J").column
Sheets("Sheet1").Range(Cells(1,iCol1), Cells(1,iCol2)).entirecolumn

Skip,

_[red][/red]

 

[PHV]

You may try this:
.Range(Var & ":J")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[markozzz]

Thank you both!
I used PHV`s method, but im sure it both works.

Rgds,
markozz