Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
start point: formula in col. B
directions: go to col. A, step upward 'til reach non-blank cell end point: use contents of $A# inside the formula I can physically find the required data using Go To (or even [End] + arrow-up key) but how would one write a macro to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions |