| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find the first unfrozen row in Excel using VBA?
This is probably so easy but I'm more experianced in VBA for Word. I have a
large workbook (33 sheets) that is used as a template. Each sheet is frozen at a different line, due to informaton above the freeze point that is different for each sheet. I need to determine what the first unfrozen row is for formatting purposes, but for the life of me can't figure it out. Is there an equivilent to "SplitRow" like "FreezeRow" or do I have to try and do something wierd like "SendKeys(^{HOME})"? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't find the FIND in Excel | Excel Discussion (Misc queries) | |||
| Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| How do I freeze a pane on Excel but leave one line unfrozen? | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Threaded Mode
