Need a specific range in the Publishobject for VBA

Vote count:

0

I need to get a specific range to be published like $A$1:$O$$25 instead of xlSourceSheet

With ActiveWorkbook.PublishObjects.Add("$A$1:$O$$25", _ x, Sname, , _ xlHtmlStatic, , "") Range("A1").Activate .Publish (True) .AutoRepublish = False '~~> True updates HTML when workbook is saved End With

The above is throwing an error.

asked 33 secs ago

user3670700

6

Need a specific range in the Publishobject for VBA