| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Visual Formula Help For Adding
I have a formula stating Range("G5000").End (x1up).Select and am wanting to
add to this where in the selected cell you add 1 + the first cell up. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Visual Formula Help For Adding
1) First of all it should read: XLUP and not X1UP.
2) Your - after correction - formula selects the last filled cell in a range. I'm not sure I understood the rest of your requext... Assuming that the last cell being selected. by the command - what do you want to do from this point and on...? Micky -- והמשך/י, *א, לקרוא את השורה הבאה: *********** אם תגובתי עזרה לחץ/י, *א, על <כן בפס האופקי התחתון! *********** מיכאל אבידן מ*הל פורום "אופיס" ב"תפוז" [Microsoft" Most Valuable Professional [MVP" "Jeremy" wrote: I have a formula stating Range("G5000").End (x1up).Select and am wanting to add to this where in the selected cell you add 1 + the first cell up. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a dymanic formula to a cell using visual basic | Excel Discussion (Misc queries) | |||
| Adding a dymanic formula to a cell using visual basic | Excel Discussion (Misc queries) | |||
| excel formula - possibly visual basic method | Excel Discussion (Misc queries) | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
| Formula in Visual Basic For Excel | Excel Discussion (Misc queries) | |||
Linear Mode
