Setting a range

My question is why do I get the following error when I'm trying to set the range for a variable. My coding is also below.

Error message:

(Run-time error '1004)
"method range of object _global failed"


Coding:

Dim rSortRange As Range
Set rSortRange = Range("A1:H" & Range("H" & Rows.Count).End(xlUp))


I'm new to VBA so go easy on me. Thank you.

You are missing a parenthesis.

Please Login or Register  to view this content.

Thanks to both of you for replying so quickly.

HaHoBe your coding looks to have solved my problem.

Dim rSortRange As Range
Set rSortRange = Range("A1:H" & Range("H" & Rows.Count).End(xlUp).Row)

Originally Posted by HaHoBe

Hi, BrownBoy,

try either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Ciao,
Holger

It is the exact same thing I posted...