Select last cell in Selection

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

I am trying to write some VBA to use the row number of the last cell
in selection as a variable. How do you set this as a variable?

Thanks,
Jay
 
Const whatColumn as String = "A"
Dim lastrow
lastrow = Range(whatColumn & Rows.Count).End(xlUp).Row
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting all cells with content using a variable 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Range to Last Cell 1
VBA to select all cells with content 2
Excel VBA setting Ranges 2
cell references in vba 6
Defining a Range using Variables 3
Excel VBA 1

Back
Top