It should work for all sheets upon selection.
May be you have put it at a wrong place. See the attached example.
HTH
On Wed, May 15, 2013 at 10:55 AM, Prabhu Pinky wrote:
> hi experts..
>
> actually its not working...
>
> kindly help me on this...it clears only sheet 1 contents... if i select
>
hi experts..
actually its not working...
kindly help me on this...it clears only sheet 1 contents... if i select
sheet 2 or other sheets and if i run the macro its not clearing. its works
only on sheet 1.
On 15 May 2013 10:35, Prabhu Pinky wrote:
> hi experts,
>
> i got the answer for my late
hi experts,
i got the answer for my latest post.
below is the one i found myself :
Sub clearcontents()
ActiveSheet.Cells.clearcontents
End Sub
Regards,
Prabhu R
On 15 May 2013 10:25, Prabhu Pinky wrote:
> hi experts,
>
> what is the code to clear the contents including formats in active she
hi experts,
what is the code to clear the contents including formats in active sheet?
if im in sheet 1and if i run the macro it should clear only the sheet 1
data, if i go to sheet to and if i run the macro it should clear only the
sheet 2 data.
please help.
regards,
prabhu r
--
Are you =EXP
