Select Range

  • Thread starter Thread starter K
  • Start date Start date
K

K

Hi all, how can i select range from B2 to last value cell to left in
row 1 by macro. please can any body can help
 
Sub selectrange()
Range(Cells(2, 2), Cells(2, Cells(1, Columns.Count) _
.End(xlToLeft).Column)).Select
End Sub
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Run Macro If Cell have "x" value 0
I must make certain I have a specific range of numbers present. 3
Clear a "moving" range offset from Target 31
Range formula copy 4
Advice on multiple macros, same code just a different column 9
Adding a WHERE statement 3

Back
Top