ExcelBanter - How do i get VB to reckognise an empty cell when excel thinks it's

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do i get VB to reckognise an empty cell when excel thinks it's (https://www.excelbanter.com/excel-programming/331547-how-do-i-get-vbulletin-reckognise-empty-cell-when-excel-thinks-its.html)

Chris

How do i get VB to reckognise an empty cell when excel thinks it's

Confused??
I have vb copy a section of a sheet with formulas in and then paste it to
another workbook as values to remove the formulas and leave the results.
I want to set up a check to look for cells that are blank in specific
columns, the problem being that where there was a formlua excel thinks there
is something in the cell and ignores it.
Does anyone know of a way round this, either before the copy or after the
paste?

Bob Phillips[_7_]

How do i get VB to reckognise an empty cell when excel thinks it's

Use LEN

IF Len(Range("A1").Value) = 0 then
...

--
HTH

Bob Phillips

"Chris" wrote in message
...
Confused??
I have vb copy a section of a sheet with formulas in and then paste it to
another workbook as values to remove the formulas and leave the results.
I want to set up a check to look for cells that are blank in specific
columns, the problem being that where there was a formlua excel thinks
there
is something in the cell and ignores it.
Does anyone know of a way round this, either before the copy or after the
paste?

All times are GMT +1. The time now is 07:50 PM.