Capture current WS Name?

[Guest]

I want to run a Macro that starts in "the current" WS, briefly jumps to a
different WS (always the same one) Grabs the Format of a particular Column,
and returns to do a Paste Special. I need to be able to capture the Name of
the current WS into a Variable at the top of the Macro, so that I can return
to the correct WS to continue.

Help, please!

 

[merjet]

Activesheet.Name

Merjet

 

[Don Guillett]

Why bother to waste time and effort by going there.

Sub copysh8colhformat()
Sheets("sheet6").Columns("H").Copy
Columns(ActiveCell.Column).PasteSpecial Paste:=xlPasteFormats
End Sub

 

[Guest]

Thanks to both of you -- now I have the direct answer to my question, should
I ever need to use it in some other context, and your solution which is
application specific, and slicker 'n a pig in poop <g>!
--
Dave
Temping with Staffmark
in Rock Hill, SC

Why bother to waste time and effort by going there.

Sub copysh8colhformat()
Sheets("sheet6").Columns("H").Copy
Columns(ActiveCell.Column).PasteSpecial Paste:=xlPasteFormats
End Sub

 

[Don Guillett]

I might have preferred a cleaner kudo. You're not a Texas Aggie, by chance.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Thanks to both of you -- now I have the direct answer to my question,
should
I ever need to use it in some other context, and your solution which is
application specific, and slicker 'n a pig in poop <g>!

 

[Guest]

No, actually -- Canadian by birth, British by heritage, and South Carolinian
by the Grace of God <g>!