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!
--
Dave
Temping with Staffmark
in Rock Hill, SC

Activesheet.Name

Merjet

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
SalesAid Software
(E-Mail Removed)
"Dave Birley" <(E-Mail Removed)> wrote in message
news:B375A619-743E-4603-AB7A-(E-Mail Removed)...
>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!
> --
> Dave
> Temping with Staffmark
> in Rock Hill, SC

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


"Don Guillett" wrote:

>
>
> 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
> SalesAid Software
> (E-Mail Removed)
> "Dave Birley" <(E-Mail Removed)> wrote in message
> news:B375A619-743E-4603-AB7A-(E-Mail Removed)...
> >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!
> > --
> > Dave
> > Temping with Staffmark
> > in Rock Hill, SC
>
>

I might have preferred a cleaner kudo. You're not a Texas Aggie, by chance.
<G>
>>slicker 'n a pig in poop

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Dave Birley" <(E-Mail Removed)> wrote in message
news:2CEE7BD3-5F98-418F-9F9E-(E-Mail 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>!
> --
> Dave
> Temping with Staffmark
> in Rock Hill, SC
>
>
> "Don Guillett" wrote:
>
>>
>>
>> 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
>> SalesAid Software
>> (E-Mail Removed)
>> "Dave Birley" <(E-Mail Removed)> wrote in message
>> news:B375A619-743E-4603-AB7A-(E-Mail Removed)...
>> >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!
>> > --
>> > Dave
>> > Temping with Staffmark
>> > in Rock Hill, SC
>>
>>

No, actually -- Canadian by birth, British by heritage, and South Carolinian
by the Grace of God <g>!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Don Guillett" wrote:

> I might have preferred a cleaner kudo. You're not a Texas Aggie, by chance.
> <G>
> >>slicker 'n a pig in poop
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Dave Birley" <(E-Mail Removed)> wrote in message
> news:2CEE7BD3-5F98-418F-9F9E-(E-Mail 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>!
> > --
> > Dave
> > Temping with Staffmark
> > in Rock Hill, SC
> >
> >
> > "Don Guillett" wrote:
> >
> >>
> >>
> >> 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
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "Dave Birley" <(E-Mail Removed)> wrote in message
> >> news:B375A619-743E-4603-AB7A-(E-Mail Removed)...
> >> >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!
> >> > --
> >> > Dave
> >> > Temping with Staffmark
> >> > in Rock Hill, SC
> >>
> >>
>
>