nenadmail
05-23-2012, 03:41 AM
Hello,
I am trying to use the code provided on:
vbaexpress.com/kb/getarticle.php?kb_id=512
It is set to check the worksheet for entry, if no entry in a range of cells, then the entire row hides. Otherwise, it unhides.
And it works fine except for two things....
1. First, it brings up an error when I set the range to "A" only
'< Set the columns that may contain data >
Const FirstCol As String = "A"
Const LastCol As String = "A"
It only works when I set the range to have at least 2 columns, like this:
'< Set the columns that may contain data >
Const FirstCol As String = "A"
Const LastCol As String = "B"
2. And secondly, it only shows rows with numbers and hides rows with text. But I have both numbers and text. I'm a layman to coding... So, can you please send me a new code that will work for me?
Thank you very much!
I am trying to use the code provided on:
vbaexpress.com/kb/getarticle.php?kb_id=512
It is set to check the worksheet for entry, if no entry in a range of cells, then the entire row hides. Otherwise, it unhides.
And it works fine except for two things....
1. First, it brings up an error when I set the range to "A" only
'< Set the columns that may contain data >
Const FirstCol As String = "A"
Const LastCol As String = "A"
It only works when I set the range to have at least 2 columns, like this:
'< Set the columns that may contain data >
Const FirstCol As String = "A"
Const LastCol As String = "B"
2. And secondly, it only shows rows with numbers and hides rows with text. But I have both numbers and text. I'm a layman to coding... So, can you please send me a new code that will work for me?
Thank you very much!