Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |