Macro Help Object required error

[wonderd]

I have a macro that replaces all empty cells in collumn N and P to the last row of data with the value of textbox62 on a userforum. However the macro is throwing a run time object required error. Does anyone know what this might be? This is the macro

Please Login or Register  to view this content.

This is the code that gets highlighted in the debug

Please Login or Register  to view this content.

[HaHoBe]

Hi, wonderd,

maybe there are no cells of the given type (really blanks, no formulas) in the area you work on or the whole area is empty?

Please Login or Register  to view this content.

And you should consider to add the number of the RTE (1004) as well as to change the thread title.

Ciao,
Holger

[wonderd]

There are real blanks.

[wonderd]

The workbook can be seen at the below link with the above code

http://varietyrugs.com/Interface2.zip

Just have to hit run to see the error.

[wonderd]

Could someone help on this please?

[wonderd]

This has been solved.

[wonderd]

This has been solved.

[HaHoBe]

Hi, wonderd,

would you please post the solution to this thread?

Ciao,
Holger

[wonderd]

Sure. I needed to reference the userform

Please Login or Register  to view this content.