range().select function in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a macro, how do you select a range of cells relative to the current
position.
i.e. range(RC,[R+1C+8]).select <=tried this but does not work

Selecting from current row and column position, to the next rox, and next 8
columns.
Thanks
 

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
macro to copy rows that contain a cell with a certain number 2
File Name changes with dates and Deleting Rows of Zeros 0
Macro that deletes and pastes filterd rows and then some 2
Combine 2 columns in a dynamic range into one 7
Different Results from the Same Macro 2
VBA Pivot Table Error 1
Advice on multiple macros, same code just a different column 9

Back
Top