ExcelBanter - empty ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - empty ranges (https://www.excelbanter.com/excel-discussion-misc-queries/10292-empty-ranges.html)

empty ranges

hi all,
what would be the vb code to chech a range to see if
anything (data) was there. say range j12:x12.

thank you in advance
S1

Bob Phillips

Maybe

If Application.CountA(Range("J12:X12")) 0 Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)

"S1" wrote in message
...
hi all,
what would be the vb code to chech a range to see if
anything (data) was there. say range j12:x12.

thank you in advance
S1

thank you Bob
S1
-----Original Message-----
Maybe

If Application.CountA(Range("J12:X12")) 0 Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)

"S1" wrote in
message
...
hi all,
what would be the vb code to chech a range to see if
anything (data) was there. say range j12:x12.

thank you in advance
S1

.

All times are GMT +1. The time now is 02:51 PM.