Range issues inside macro

[RASelkirk]

Hi All,

I made a macro that extends my sheet by adding borders to two new rows. It works as long as the new cells (range) are hard-coded, but when I try using variables to define the range it throws errors. This is a small test sheet that I've been trying to get to work, I will upload it in full.

Here's what I'm seeing. In the pic, the error shows my range object with double quotes while the debug window shows the expected single quotes. If I copy the exact line from the DB window and paste it into my range (), the code works.

macro quotes.jpg

And here's "test.xls" for your scrutiny.

Russ

[TMS]

Just myRange = firstCol & lastCol

[JohnTopley]

try

Set myRange = Range(firstcol & lastcol)

and

myRange.Select

[RASelkirk]

Just myRange = firstCol & lastCol

Doh! That must have been the one iteration I failed to try. Works perfect, no quotes required.

Russ

[TMS]

You're welcome.