Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looking through entire sheet
I need to look at every cell in the sheet and if it has "#N/A" then I need to
replace it with "" . I know of a long way to do it (looping through each cell in each column), but I wanted to see if anyone new of a shorter way to just look through the whole sheet. So far I have this... and I would do this for each column. I'm using Visual Studio rather than VBA but its similar. Thanks! For i = 1 To lastRow If oApp.Range("B1:B" & lastRow).Value = "#N/A" Then oApp.Range("B" & i).Value = "" End If Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit for entire sheet? | Excel Programming | |||
Copy Entire Sheet | Excel Discussion (Misc queries) | |||
Moving An Entire Row From One Sheet To Another | Excel Discussion (Misc queries) | |||
Copy the entire sheet to overlay existing sheet? | New Users to Excel | |||
Subtract entire sheet? | Excel Worksheet Functions |