| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Well, how hidden is it ??
I have noticed that if I hide a row and then set a range across that hidden
row, the value gets applied to the hidden cell: Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").Value = 1 Range("A2").EntireRow.Hidden = False End Sub The value gets applied to A2, even though the cell was hidden. If, however, I hide the row using AutoFilter, the value in A2 does not get changed. It is possible to apply this type of hiding without using AutoFilter?? -- Gary''s Student - gsnu200908 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Well, how hidden is it ??
On Nov 16, 3:47*pm, Gary''s Student
wrote: I have noticed that if I hide a row and then set a range across that hidden row, the value gets applied to the hidden cell: Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").Value = 1 Range("A2").EntireRow.Hidden = False End Sub The value gets applied to A2, even though the cell was hidden. *If, however, I hide the row using AutoFilter, the value in A2 does not get changed. *It is possible to apply this type of hiding without using AutoFilter?? -- Gary''s Student - gsnu200908 Good question, i don't have an answer, but I suggest doing it via autofilter then (in code) turn the autofilter off. Maybe that would work? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Well, how hidden is it ??
Try it this way...
Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").SpecialCells(xlCellTypeVisible).Val ue = 1 Range("A2").EntireRow.Hidden = False End Sub -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... I have noticed that if I hide a row and then set a range across that hidden row, the value gets applied to the hidden cell: Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").Value = 1 Range("A2").EntireRow.Hidden = False End Sub The value gets applied to A2, even though the cell was hidden. If, however, I hide the row using AutoFilter, the value in A2 does not get changed. It is possible to apply this type of hiding without using AutoFilter?? -- Gary''s Student - gsnu200908 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Well, how hidden is it ??
Thanks Rick, good suggestion.
-- Gary''s Student - gsnu200908 "Rick Rothstein" wrote: Try it this way... Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").SpecialCells(xlCellTypeVisible).Val ue = 1 Range("A2").EntireRow.Hidden = False End Sub -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... I have noticed that if I hide a row and then set a range across that hidden row, the value gets applied to the hidden cell: Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").Value = 1 Range("A2").EntireRow.Hidden = False End Sub The value gets applied to A2, even though the cell was hidden. If, however, I hide the row using AutoFilter, the value in A2 does not get changed. It is possible to apply this type of hiding without using AutoFilter?? -- Gary''s Student - gsnu200908 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Well, how hidden is it ??
You are welcome. By the way, don't forget to put in some error trapping in
your general code just in case all the cells are hidden. -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... Thanks Rick, good suggestion. -- Gary''s Student - gsnu200908 "Rick Rothstein" wrote: Try it this way... Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").SpecialCells(xlCellTypeVisible).Val ue = 1 Range("A2").EntireRow.Hidden = False End Sub -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... I have noticed that if I hide a row and then set a range across that hidden row, the value gets applied to the hidden cell: Sub sub1() Range("A2").EntireRow.Hidden = True Range("A1:A3").Value = 1 Range("A2").EntireRow.Hidden = False End Sub The value gets applied to A2, even though the cell was hidden. If, however, I hide the row using AutoFilter, the value in A2 does not get changed. It is possible to apply this type of hiding without using AutoFilter?? -- Gary''s Student - gsnu200908 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
Linear Mode
