Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
code failing in hidden rows
I have the following code as part of other code which is executed via a
UserForm. With Sheet4 .Range("V13:V20").Value = .Range("R5:R12").Value End With When I unhide those rows the code works fine. Part of the range, namely rows 16 to 23 are hidden. When I execute this code, those cells located within the hidden range do not reflect the values from the R5:R12 range. No error message appears, yet only values are copied into the unhidden cells. Other parts of the code within this procedure do copy the value to the cells in the hidden range, eg.... If Range("U9") = True Then Range("V17") = CloseBal Can anyone see a problem here? Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Unhiding All hidden Worksheets with a Macro/VBA Code | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |