You're right, I was using a string.
I just had to qualify it more.

dim stRange as string
stRange = "a1:" & xlApp.ActiveCell.Address
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"Mark" wrote:


I am not sure how you have declared your StRange Variable. The
following example does work though...

Dim stRange As String

stRange = "A1:" & ActiveCell.Address
Debug.Print stRange
Range(stRange).Select

I assumed you were using a string and not a Range Object. Hope that
helps