Find and Replace Question
Well this is what I have in VS:
On Error Resume Next
oApp.Range("A1:X16").Replace("#N/A", "", XlLookAt.xlPart,
XlSearchOrder.xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False)
oAppBk11.Save()
oAppBk11.Close()
oApp is the excel object and oAppBk11 is the workbook name.... it still
gives me the message box, any ideas?
"David Hilberg" wrote:
I don't use Visual Studio, but in VBA you could eliminate the messagebox:
On Error Resume Next
ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, 16).Select
For Each c In Selection
If c.Text = "#N/A" Then c.Value = ""
Next c
Or did you wnat to see the messagebox for a few seconds and then have it
disappear automatically?
- David
NewToVB wrote:
I'm using Visual Studio 2005 rather than VBA to write this program. I needed
to find and replace all "#N/A" with "". If there are no "#N/A" s in the
worksheet I get a message box from excel saying there was no data to
replace... what code would i need to close this message box without having to
do it manually? Thanks!
|