I want to define title rows -1004 ...

  • Thread starter Thread starter Kerstin Schiebel
  • Start date Start date
K

Kerstin Schiebel

Hi,

I need to define title rows via VBA (Excel 2002).
---
Dim objWS As Worksheet
Set objWS = ActiveWorkbook.Worksheets("Stueckliste")

' ActiveWorkbook.Worksheets("Stueckliste").Select

objWS.Activate

With objWS.PageSetup
' .PrintTitleRows = objWS.Rows("1:11").Address <--- 1004
.PrintTitleRows = "$1:$11"
<--- 1004
.PrintTitleColumns = ""
---
On some PCs I get the error "1004 - Die PrintTitleRows-Eigenschaft des
PageSetup-Objektes kann nicht festgelegt werden".
(I do not know what is the exactly description in English).
On my own PC (and other ones) this is no problem!
I do not know what is the problem.
Has anyone an idea what goes wrong?

Thank you
Regards Kerstin
 
Please check whether printer is installed in other PCs

If this post helps click Yes
 
YES :-))))
(the actual default printer had a problem with the connection)

Thank you very much!
Kerstin

Jacob Skaria said:
Please check whether printer is installed in other PCs

If this post helps click Yes
....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top