"Master - INPUT w.Range("B3:K" & lrx).Clear End If .">
  • Hot Topics

Excel Are watermarks considered a merged cell?

Hello, I am helping my wife with a spreadsheet she is using for work and it was up and working fine, thanks to help I had received previously. But now she and one of her coworkers were asked to add a watermark to the sheet on each tab. Now when the script is called it stops and give the following errors: Run-time error '1004': cannot change part of a merged cell. I searched for merged cells in the document and as far as the script is concerned there are none, other than maybe this new watermark. So, does VBA or scripting think that a watermark is a merged cell? Is there any kind of a workaround if it does think of it as being merged? Here is the current script we are using: Code: Sub CopyFmMaster() 'Developed by ASidman 1/27/2014 Set Rng = ActiveCell Application.ScreenUpdating = False Application.Run ("Unprotect_all_sheets") 'Delete all information in Range Dim w As Worksheet For Each w In Worksheets Dim lrx As Long lrx = w.Range("B" & Rows.Cou If w.Name <> "Master - INPUT w.Range("B3:K" & lrx).Clear End If

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel