Variable range

[rutgerterhaar]

Hi there,

I've got a short question: I have two variable ranges:
One in row 4, starting in column F
One in Column E, starting in row 5

I want to set a range for a macro for these two variable ranges. So one is Range("F4:.....") and the other one is Range("E5,....). I have to find the Last filled column for the first one and the last filled column for the second one. I know how to do that, but how do I get this in the range??

This is probably a simple question, but I couldn't find it on the forum.

I hope the question is clear to you guys!

Thanks!!!!!

Rutger

 

[Andrew Poulsom]

Try:

Sub Test()
    Dim Rng As Range
    With ActiveSheet
        Set Rng = .Range(.Range("F4"), .Cells(4, .Columns.Count).End(xlToLeft))
        MsgBox Rng.Address
    End With
End Sub

 

[rutgerterhaar]

Thanks for you're quick reply!! It works perfect!!

Rutger