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
Thanks for Help
On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote:
>
> Try this one !
>
> [dp]
>
> On 10/10/2016 19:46, sonur...@gmail.com wrote:
>
> Hi
>
> I need help for separate data through VBA.
>
> My Data is below type..
> sku Size
> 10307963 XS,S,M,L
> 103
Use this Man
Sub SplitTest()
Dim VarArrayAs Variant
Dim LngRAs Long
Dim LngCAs Long
Dim LngIndexAs Long
Dim VaresultAs Variant
LngIndex = 1
VarArray = Intersect(Sheet2.Range("A1").CurrentRegion,
Sheet2.Range("A1").CurrentRegion.Offset(1))
Hi Try below VBA code
Option Base 1
Sub rr()
For Each r In Range("b2:b" & Range("b9").End(xlUp).Row)
x = Split(r, ",")
For t = LBound(x) To UBound(x)
Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1)
Range("i9").End(xlUp).Offset(1).Value = x(t)
Next
Next
End S
Try this one !
[dp]
On 10/10/2016 19:46, sonuraj1...@gmail.com wrote:
Hi
I need help for separate data through VBA.
My Data is below type..
sku Size
10307963XS,S,M,L
10307973XS,S,L
10307978XS,S,M,L
10307979XS,S,L
10307980XS,S,XL
10307981XS,S,M,L
10307984XS,M,
Hi,
Can you share your Macro ?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of girish naik
Sent: Apr/Tue/2012 10:28
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help in VBA
Hi,
I need to write a vba script wherein the m
13 matches
Mail list logo
