check if range containing values

  • Thread starter Thread starter Markus Serbel
  • Start date Start date
M

Markus Serbel

hi,

how can I check, if a cell range ( range("A1", "A5") ) contains any values?
i need to know, if the cells are empty.

thanks,
markus
 
J.E. McGimpsey said:
Dim numVals As Integer
numVals = Application.CountA(Range("A1:A5"))
If numVals = 0 Then MsgBox "All Empty"
Click to expand...

thank you! :)
markus
 
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

VBA set thick borders around non empty cells in range 0
Excel formula, sum the value cell and if empty cell left blank 0
Convert A1 value to a sheet name and copy to it 2
A little help needed please... 7
Code works on sheet but not from code-to-sheet 2
Run Macro If Cell have "x" value 0
REARRANGEMENT OF CELL VALUES !! 4
CONCATENATING CELL CONTENTS ! 2

Back
Top