Selecting a range of cells
Bernie,
Works great!
Thanks!
Kevin
-----Original Message-----
Kevin,
Dim myRow As Long
myRow = ActiveCell.Row
Range(Range("B" & myRow), Range("F" & myRow)).Select
HTH,
Bernie
"Kevin" wrote in message
...
I have recorded a macro to select a range of cells,
merge
them, and wrap the text. The problem I have is the macro
returns to the row on which the macro was recorded. How
do
I have the macro select say columns B through F relative
to the row I am on, then perform the rest of the macro.
Thanks in advance!
Kevin
.
|