tony.reynolds
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 97
I have a macro that selects all cells that have data in a column. the only problem is my cells have a formula and it selects these as well even when the formular results in ""
formular in the cell is =IF(B13="","",C13&","&B13)
Macro is
Range(ActiveCell, (Cells(65536, ActiveCell.Column).End(xlUp))).Copy
formular in the cell is =IF(B13="","",C13&","&B13)
Macro is
Range(ActiveCell, (Cells(65536, ActiveCell.Column).End(xlUp))).Copy