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 the
clipboardand
pa
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 Paul,
I want to know each worksheet is linked to what source.
This I want to do because say suppose one source is incorrect, through
this I will know it will affect which worksheets of my workbook.
Regards,
Kaushik
On May 24, 2017 00:17, "Paul Schreiner" wrote:
So, you're wanting to fin
So, you're wanting to find out what other documents are being linked?
something like this will count the number of referenced links:
cnt = 0
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
' MsgBox alinks.Count
If Not IsEmpty(alinks) Thenmsgbox "Links: " & UBound(alinks)
Hi Team,
I have several huge data files.
Each file has links to several worksheets and several workbooks.
Can anyone help me with a vba code which will go in each worksheet of
workbook and will fetch me result mentioning each worksheet has source from
which worksheets/workbooks.
Doing it manu
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)
Hey guys
If any one have opening in excel frasher job pls call me 9990517398
I looking job urgency basis.
🙏
On 23 May 2017 1:26 p.m., "Vijayendra Rao" wrote:
Hi Experts,
I have created one reconciliation statement in which I need to do many
manual work. Is there any option which i can ea
Thanks Paul. The concatenation is a good idea so I can 'force' them to be
considered as one in the list. Looks like I'm forced to used helper cells
to complete the count? I don't believe you can pass an array argument into
the concatenation function?
On Tue, May 23, 2017 at 7:23 AM, Paul Schrei
There are several approaches.Using Excel functions, I would concatenate the
values;=A2&"_"&B2which would result in:SNUser1001 25 1001_251002 25
1002_251003 26 1003_261001 25 1001_251004 26 1004_26
Then you can use your functions to count unique values of column C.
You can do so
Hi Experts,
I have created one reconciliation statement in which I need to do many
manual work. Is there any option which i can easily prepare by any
functions or macros. Request you to help on the same.
Excel file is attached.
Regards,
Vijayendra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
14 matches
Mail list logo