| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering value into cell in macro
Hi,
I've got several macrobuttons that hide rows in sheet 2 so that only certain cells can be filled in eg Row 16 will be hidden. When this option is chosen row 16 is not filled in and in C25 even rows C2-C20 will be summed. C16 is still in this formula but because it is empty it doesn't add anything. At this stage I'm not worrying about C16 getting filled in and then option to hide it is selected - hmm trouble for later methinks- C27 has the formula C25/10 but I thought that I could use H1 which will be a hidden cell C25/H1. The plan was to put a value for H1 into each of the macros which hide different rows. I'm very much a newbie - limited to record, fiddle copy from the net so any help appreciated Thank you -- TD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem entering data in hidden cell, via macro | Excel Programming | |||
| How to make a macro or function run after entering data in a cell? | Excel Worksheet Functions | |||
| Can a macro be made to run on entering or leaving a cell? | Excel Discussion (Misc queries) | |||
| Entering Time Macro | Excel Worksheet Functions | |||
| Macro entering data into a protected Cell?? | Excel Discussion (Misc queries) | |||
Threaded Mode
