| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a 'frozen' cell
I have a budget spreadsheet : cell B4 says 'REVENUES' and cell B20 says
'EXPENSES'. That's fine when I print the spreadsheet. For onscreen viewing, I 'freeze' rows A:1 thru A:8. When the screen scrolls to row 21, I want cell B4 to say 'EXPENSES'. What IF statement or macro code will switch the dispaly in cell B4 when I 'freeze' the titles. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Programming Cell ID's | Excel Discussion (Misc queries) | |||
| Colour change in frozen colum when cell group is completed | Excel Discussion (Misc queries) | |||
| move to adjacent cell with panes frozen | Excel Discussion (Misc queries) | |||
| Returning reference of frozen cell | Excel Programming | |||
| Frozen is cell | Excel Discussion (Misc queries) | |||
Threaded Mode
