| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA for Last Cell in Formula Range
Using VBA
Trying to indentify the last cell on sheet that has a formula. code fragment below have tried Set rge = Sh.UsedRange.SpecialCells(xlCellTypeFormulas, xlCellTypeLastCell) msgbox rge.Address However I this returns the address of all formula cells Any suggestions to get the address of the last cell with a formula ? ie used range a1: j 100 , and last formula may be j 89 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to use a cell Value as a named Range in a Formula | Excel Worksheet Functions | |||
| Need a formula that finds the last used cell in a range | Excel Worksheet Functions | |||
| formula for named cell/range using cell values | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| How do I use text in a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
