N
niall
Hi,
I am a newbie to this group but I have been unable to find a
solution to my problem, so I decided to post it here in the hope that
someone might be able to help.
Issue :
I have a spreadsheet which contains data in rows 6 through 22.
However, some rows have been 'frozen' (i.e. by taking Windows /
Unfreeze they re-appear).
If I look at the sheet, the rows are numbered 5 and then 15. Rows 6
to 14 inclusive are not visible
I am trying to programatically exclude any rows that are not
visible.
I have tried the following lines of code to no avail :
"If Worksheets(strsheetname).Rows(inti).Visible = True Then x = 1 Else
x = 2"
"If Worksheets(strsheetname).Rows(inti).Hidden = True Then x = 1 Else
x = 2"
I also did some trials using the property Visiblerange but once
again, it wasn't coming back as false which would allow me to set the
flag I require.
Thanks in advance for any suggestions,
Niall Heelan
I am a newbie to this group but I have been unable to find a
solution to my problem, so I decided to post it here in the hope that
someone might be able to help.
Issue :
I have a spreadsheet which contains data in rows 6 through 22.
However, some rows have been 'frozen' (i.e. by taking Windows /
Unfreeze they re-appear).
If I look at the sheet, the rows are numbered 5 and then 15. Rows 6
to 14 inclusive are not visible
I am trying to programatically exclude any rows that are not
visible.
I have tried the following lines of code to no avail :
"If Worksheets(strsheetname).Rows(inti).Visible = True Then x = 1 Else
x = 2"
"If Worksheets(strsheetname).Rows(inti).Hidden = True Then x = 1 Else
x = 2"
I also did some trials using the property Visiblerange but once
again, it wasn't coming back as false which would allow me to set the
flag I require.
Thanks in advance for any suggestions,
Niall Heelan