Re: Pasting Blanks using a macro
- From: TTomSawyer <TTomSawyer.1tv4al_1124204789.1909@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 09:28:09 -0500
Hrm,
this didnt work, it resulted in a few errors.
specifically regarding the line with
ws1.Range("B7", Range("B7"). _
End(xlDown)).Offset(0, -1).Resize(, 2).Copy
--
TTomSawyer
------------------------------------------------------------------------
TTomSawyer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20511
View this thread: http://www.excelforum.com/showthread.php?threadid=395945
.
- Follow-Ups:
- Re: Pasting Blanks using a macro
- From: Norman Jones
- Re: Pasting Blanks using a macro
- References:
- Pasting Blanks using a macro
- From: TTomSawyer
- Re: Pasting Blanks using a macro
- From: Norman Jones
- Pasting Blanks using a macro
- Prev by Date: Re: Newbie Q - outlook & Excel
- Next by Date: Re: Macros for Protect/Unprotect all sheets in a workbook
- Previous by thread: Re: Pasting Blanks using a macro
- Next by thread: Re: Pasting Blanks using a macro
- Index(es):
