Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem entering data in hidden cell, via macro
I have used InputBox to enter data in a visible cell without a problem but it
doesn't work when the cell is in a hidden column. (See code below) QtyCol = Range("Rpt_Qnty").Column mnextrow = Cells(Rows.Count, StkCol).End(xlUp).Row + 1 ip = InputBox("Enter Quantity", "Quantity") Cells(mnextrow, QtyCol).Value = ip How can I use similar code to enter a value into a cell in a hidden column? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Formula - Cannot select cell as it is hidden by formula | Excel Worksheet Functions | |||
How to make a macro or function run after entering data in a cell? | Excel Worksheet Functions | |||
Hidden cell problem | Excel Programming | |||
Macro entering data into a protected Cell?? | Excel Discussion (Misc queries) | |||
macro for "entering data" | Excel Worksheet Functions |