Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code
Public Sub test() Dim cfind As Range Dim x As Range Dim cell As Range Dim myrange As Range Worksheets("printing").Activate Set myrange = Range(Range("a3"), Cells(Rows.Count, 1).End(xlUp)) For Each cell In myrange Worksheets("planning").Activate With Range("e3:e61") Set cfind = .Cells.Find(what:=cell.Value, lookat:=xlWhole) Set x = cfind.End(xlToLeft) End With Worksheets("printing").Activate cell.Offset(0, 3) = x line20: Next cell End Sub It almost does the job however if the value in in worksheet("printing") is not found then it stops and shows an error. I would like it not to show an error but return a blank value into the the worksheet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code error | Excel Programming | |||
Error Code 6 | Excel Programming | |||
How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
More to Error in code | Excel Programming |