How to set a range of cells

  • Thread starter Thread starter G Lam
  • Start date Start date
G

G Lam

Hi,
I recorded a macro and changed it as follow:

Range("B4").Select
Selection.End(xlDown).Offset(0, 1).Select

If I want to set a range from the last selected cell to B4, how should I go
on with the above?
Thank you.
GL
 
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

Excel Macro to use cells as a autofilter 0
Run-time error 1004 paste method of worksheet class failed 3
macro problem: range offset question 6
Getting a Cell Value into a Macro! 2
Can Vba workout if a selection is part of a group? 0
Macro Pause for selecting cell 3
File Name changes with dates and Deleting Rows of Zeros 0
Use xldown to select a range of cells 6

Back
Top