Excel 4 macro
 

I have an old spreadsheet with excel 4 macro's that I am trying t
update. I am having a problem with the following line.
" =SELECT("R[5]C:R[324]C") "
If I select a column then run the macro it will select rows 5 throug
324 in whatever column I have selected. I want to update this to VBA i
excel 2000. Any suggestions

--
~~ Message posted from http://www.ExcelForum.com

Excel 4 macro
 

Range(Cells(5, ActiveCell.Column), Cells(324, ActiveCell.Column)).Select

--

Vasant

"brwilson" wrote in message
...

I have an old spreadsheet with excel 4 macro's that I am trying to
update. I am having a problem with the following line.
" =SELECT("R[5]C:R[324]C") "
If I select a column then run the macro it will select rows 5 through
324 in whatever column I have selected. I want to update this to VBA in
excel 2000. Any suggestions?


---
~~ Message posted from http://www.ExcelForum.com/