Attached Your file..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Monday, July 25, 2011 8:47 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving
same error
Doing that
Doing that, it doesn´t return the error anymore, but the macro still doesn´t
copy the information :s, is it any complication with excel 2010?
2011/7/22 Rajan_Verma
> *Set Wb=ActiveWorkbook*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of
Set Wb=ActiveWorkbook
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday, July 21, 2011 10:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same
error
Hi guys, i
add this line before if condition see if it helps
wb.Sheets("Pivot").select
On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava wrote:
> is it possible to attach the sheet? You can remove the data from it or
> replace the values..
>
>
> On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
>
>>
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
> Yes, the names are all ok, i double checked it, even try to change names,
> but doesn´t work :S
>
> 2011/7/21 Anish Shrivastava
>
>> Please check
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava
> Please check if the sheet name is "Pivot".
> if not then rename it to Pivot.
> On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
>
>> Hi guys, i have this macro i us
Please check if the sheet name is "Pivot".
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
> Hi guys, i have this macro i use to copy a range from column D of a
> worksheet of a workbook to column G of another workbook and worksheet, but
> it keeps giving me
