| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell is not empty but excel thinks it is,,,why? | Excel Discussion (Misc queries) | |||
| Excel thinks a file is ReadOnly but it is not. How to fix? | Excel Discussion (Misc queries) | |||
| Excel thinks blank columns have data? | Excel Discussion (Misc queries) | |||
| How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Template thinks it's linked to external data | Excel Programming | |||
Linear Mode
