| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula in one cell needs to use a figure from another cell but it crashes
I have the follwoing code:
If Target.Address = "$F$165" Then Rows(167).Resize(25).Hidden = True If Target.Value = "No" Then _ Rows(167).Resize(F17 * 5).Hidden = False End If F165 gives a Yes or No response. There are 25 rows hidden from 167 to 192. If the response in 165 is NO, then it is to unhide a portion of those 25 rows. The portion I want unhidded is the cell F17 times 5 (where F17 is a number between 1 and 5) However I try to write that formula around that second Resize command I get an error. I cannot figure what is wrong. Help please! RU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel workbook crashes when changing data in cell. | Excel Discussion (Misc queries) | |||
| Single-cell formula to figure multiple percentages | Excel Discussion (Misc queries) | |||
| Want to make formula automatically figure out cell number in the r | Excel Discussion (Misc queries) | |||
| Formatting a cell crashes Excel | Setting up and Configuration of Excel | |||
| Why Excel crashes everytime a cell is entered? | Excel Discussion (Misc queries) | |||
Threaded Mode
