Find & Use Cell Address To Offset On Another Worksheet

  • Hi Everyone,

    I'm still getting to grips with the Find Command. Basically, I have the below code that looks at a line in a sheet(ws_Site) based on the Line ID Number that is in column A and then Finds that that LineID_Value in a different sheet(ws_main) and copies a value from column I on that line across. Problem is, if the cell I is blank it copies it across and essentially clears the cell if there was data in it.

    How can I adjust the below code to only set ws_main.Range(c.Address).Offset(0, 8).Value = LineID_Value if LineID_Value is not blank?



  • Re: Find And Replace Only If Cell Isnt Blank

    Hi James,

    Amended code below, let me know if it works ok as I haven't tested it. It just skips the cell if the LineID_Value loaded in is empty.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!