| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lastrow in Range
Hello,
This is the VBA macro that I use: Set rng = Range("h2:h167") For Each cell In rng If IsNumeric(cell.Value) Then cell.Value = Application.WorksheetFunction. _ RoundDown(cell.Value, 2) End If Next I'd like to set the rng to automatically start from H2 to the last row in column H. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| HTML_Control Range name | Excel Discussion (Misc queries) | |||
| Invalid Range Name | Excel Discussion (Misc queries) | |||
| Macro for Show/Hide Range | Excel Discussion (Misc queries) | |||
Threaded Mode
