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? |
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 |