On Thu, 5/25/17, KAUSHIK SAVLA wrote:
Subject: Re: $$Excel-Macros$$ Links
To: "MS EXCEL AND VBA MACROS"
Cc: schreiner_p...@att.net
Date: Thursday, May 25, 2017, 9:26 PM
Could you
please share your dummy workbook which you created?
Regards,Ka
Hi Paul,
The macro for this one is not working.
Can you please share your file with macro. So i can compare with my file.
I am getting error message the data cannot be pasted as shape and size are
not same.
Regards,
Kaushik
On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner wro
Could you please share your dummy workbook which you created?
Regards,
Kaushik Savla
On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote:
>
> The workbook that you add the VBA macro to is identified as "ThisWorkbook".
>
> so, in the macro:
>
> ThisWorkbook.Sheets(1).Range(
ok...Thanks
On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote:
>
> The workbook that you add the VBA macro to is identified as "ThisWorkbook".
>
> so, in the macro:
>
> ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents
>
> clears the contents of the first sheet in "
The workbook that you add the VBA macro to is identified as "ThisWorkbook".
so, in the macro:
ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents
clears the contents of the first sheet in "Thisworkbook"then:
ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = Sht.Name
Hi Paul,
Macro got run and gave finished message.
Where can I find the desired output?
Regards,
Kaushik
On May 25, 2017 19:06, "Paul Schreiner" wrote:
> OK.
> Spent WAY longer on this than I should have.
>
> I should've had you create a "dummy" set of workbooks that looked like
> yours instea
OK.Spent WAY longer on this than I should have.
I should've had you create a "dummy" set of workbooks that looked like yours
instead of me spending an hour+ guessing what yours looks like.
So, I put together 20 separate workbooks with data.then added 15 sheets to the
"data" workbook and created 1