Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NUM!
I use the following code for a user form text box value:
Me.TextBox16.Value = Sheets("Sheet1").Range("aj34").Text Trouble is the cell "aj34" is part of an array formula and can often return:"#NUM!" Is there any way I can get a blank in my text box even when the cell returns "#NUM!". As the cell is part of an array I don't think I can stop the "#NUM!" coming up on the worksheet. gregorK |