empty ranges

  • Thread starter Thread starter S1
  • Start date Start date
S

S1

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
 
Maybe

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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)





.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a cell. 2
VBA set thick borders around non empty cells in range 0
empty variable range 6
Trying to run excel vba code when cell value changes from empty to entered value. 1
I have a complex formula where I need to build in a MAX function 4
#NA error 7
Expanding numbers and letters in a cell 4
Code to format cells on several worksheets 2

Back
Top