select range by macro

[needhelp2]

Hi,

I am using office 2010 i am creating relative macro for cells.

I am facing issue that on relative select its not selecting relative cell.Its only select select same range which i assigned while creating.
How i can fix it? PFB code.Thanks In advance.


BR,
Smith.

Sub Macro2()
'
' Macro2 Macro
'

'
    ActiveCell.Select
    Range("a:z").Select
        Selection.End(xlToLeft).Select
    Range("a5:c6").Select
    With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
        "C:\Documents and Settings\andy\Desktop\sPage.htm", "Example", "$A$7:$D$11", _
        xlHtmlStatic, "example+table+for+html_25881", "")
        .Publish (True)
        .AutoRepublish = False
    End With
End Sub

 

[iliace]

The critical piece of information that's missing is, relative to what?

 

[needhelp2]

Thanks for your reply.I was ill so that i could came online.well i mean to say that i was creating macro with relative reference, mean it work when ever i select cell throughout sheet.

 

[iliace]

OK, let me rephrase the question. What was the range you originally assigned, was it $A$7:$D$11?

Say in words what result you want to accomplish, it's difficult to make out from the code because the macro recorded your every move and not all of them are necessary.