| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Range("C9:V9").Select ==> changing the 9 to a variable
I am defining the current selector row thru this statements:
Dim Currow As Integer Currow = ActiveCell.Row Now I need to change: Range("C9:V9").Select to a variable range definition where the 9 is substituted by the value of the current row (Currow) I tried several ways of doing it by always got a "wrong syntax" error when executing. Coud you please help me ? TIA, Jorge |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Formula with changing criteria | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| changing page break in an excel file | New Users to Excel | |||
| Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
Threaded Mode
