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
What isn't working?What does your code look like?
I put random numbers in 100,000 cells in Book1.xlsbThen, in Book2, I put
100,000 cells with links to the corresponding cell in Book1.
I then created a macro module with:Option ExplicitSub RemoveLinks()
Dim aLinks, inx
aLinks = ActiveWorkbo
Hi Paul,
The code is not working.
Can you please provide full code starting with Sub...till End sub
Regards,
kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner
wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a giv
On Tue, 5/23/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Need help in Vba Macro
To: "excel-macros@googlegroups.com"
Date: Tuesday, May 23, 2017, 9:53 PM
That's
very CPU intensive because it copies all cells to th
Wow. This is what actually I require.
I will test in my file.
Thanks a lot.
On May 24, 2017 00:43, "Paul Schreiner" wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a given cell, the VALUE of the cell is what
> is displayed, wh
If you also want to get rid of the "internal" links and formulas, you can make
use of the fact that, for a given cell, the VALUE of the cell is what is
displayed, while the FORMULA of the cell is just that, the formula.
For cells with a simple value, like "3", then the formula and value are nearl
This is think will definitely help.
Thanks.
On May 24, 2017 00:23, "Paul Schreiner" wrote:
> That's very CPU intensive because it copies all cells to the clipboard
> and pastes them from clipboard.
> which can be a HUGE number of cells for each sheet.
>
> If you simply want to break the externa
That's very CPU intensive because it copies all cells to the clipboardand
pastes them from clipboard.which can be a HUGE number of cells for each sheet.
If you simply want to break the external links, you can use something like:
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsE
Hi Team,
I am trying to do below in an excel. You can assume there are 60 worksheets
minimum in a workbook.
1. In opened excel file. Which has links from several files
2. All cells of the workbook I am doing paste special values
3. Then to come at the first cell in all worksheets (i.e. Cell A1)