I'm trying to find a certain value in Accounting format within a particular range.
When I try to set the numberformat, it gives me an "Application defined or object defined error"
Here is the code:
Thank you![]()
With Range("p10:p380") With Application.FindFormat .NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* "" - ""??_);_(@_)" .VerticalAlignment = xlTop End With
Bookmarks