syntax for range and/or cell declaration

[zpierucci]

Trying to Set a range. What is the syntax if I want to use a named cell. "a1" and a variable like lastrow18. I have the variable lastrow18 set as a string and the value is stored as the last row of the column I am evaluating.

Ex: Set range18 = Range("a1:lastrow18")

What is the proper syntax to use?

 

[Fluff]

What is the value of lastrow18?

 

[zpierucci]

lastrow18 = Cells(Rows.Count, 1).End(xlUp).Row

 

[Fluff]

In that case change the Lastrow18 variable to long, not string & use

Set range18 = Range("A1:A" & lastrow18)

 

[zpierucci]

works perfect! Thanks. Is there a set syntax process for using variables and cell references? What if we were using Cells(1,1) format?

 

[Fluff]

There is no "set" way of doing things, its largely based on personal preference.
As cells is only one cell, you would need to do something like

Range(cells(1,1), cells(lastrow18,1))

 

[zpierucci]

Awesome. Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback