For the best help attach a sample workbook to your post
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: pastespecial

Search: Replies Views Search took 0.00 seconds.

PasteSpecial running error

Started by craigvan888‎, 10-14-2024 04:42 AM
- 4
- 190
Last Post By:

Last Post: 10-16-2024 03:47 AM

by alansidman

Forum:
Excel Programming / VBA / Macros
Automated: Inverting a select few values from many

Started by SeaPh03nix‎, 10-25-2022 06:22 PM
- 1
- 291
Last Post By:

Last Post: 10-26-2022 09:09 AM

by Mumps1

Forum:
Excel Programming / VBA / Macros
detect if the Paste Special command in Undo stack had Transpose as TRUE or FALSE

Started by tisouza‎, 06-13-2022 01:44 PM
- 7
- 415
Last Post By:

Last Post: 06-14-2022 08:52 AM

by carlmon

Forum:
Excel Programming / VBA / Macros
[SOLVED] PasteSpecial xlPasteValues Compile Error

Started by Gos-C‎, 12-22-2020 07:04 PM
- 2
- 2,158
Last Post By:

Last Post: 12-22-2020 07:53 PM

by Gos-C

Forum:
Excel Programming / VBA / Macros
[SOLVED] Intermittent Runtime error 1004 Paste Method of worksheet class failed

Started by dentler‎, 10-17-2020 01:24 PM
- 4
- 2,820
Last Post By:

Last Post: 10-17-2020 03:44 PM

by dentler

Forum:
Excel Programming / VBA / Macros
Macro to paste chart images to PowerPoint fails with Mac

Started by truk2‎, 01-30-2020 12:22 AM
- 1
- 778
Last Post By:

Last Post: 03-21-2023 06:26 AM

by hammerfan43

Forum:
Excel Programming / VBA / Macros
[SOLVED] how do I paste data as values

Started by tushjain00‎, 06-09-2019 08:09 AM
- 4
- 516
Last Post By:

Last Post: 06-09-2019 08:48 AM

by TMS

Forum:
Excel Programming / VBA / Macros
[SOLVED] Create a keyboard shortcut through Macro in order to copy paste special (divide)

Started by greywarden‎, 07-19-2017 09:52 AM
- 2
- 839
Last Post By:

Last Post: 07-19-2017 10:48 AM

by CK76

Forum:
Excel Programming / VBA / Macros
[SOLVED] Problem Copying between two workbook with ribbon toolbars disabled

Started by dentler‎, 02-20-2017 01:11 PM
- 1
- 406
Last Post By:

Last Post: 02-20-2017 02:08 PM

by dentler

Forum:
Excel Programming / VBA / Macros
Macro Copy, PasteSpecial and conditional formatting CountIf

Started by Nippinka‎, 08-19-2016 04:34 AM
- 2
- 510
Last Post By:

Last Post: 08-19-2016 05:10 AM

by Nippinka

Forum:
Excel Programming / VBA / Macros
[SOLVED] VBA PasteSpecial Named Range - Cannot change part of a merged cell

Started by M1234‎, 06-22-2016 05:33 AM
- 6
- 994
Last Post By:

Last Post: 06-23-2016 11:58 AM

by M1234

Forum:
Excel Programming / VBA / Macros
Pasting values from multiple worksheets into master worksheet

Started by ppp112‎, 05-01-2016 09:42 AM
- 4
- 932
Last Post By:

Last Post: 05-01-2016 10:52 AM

by ppp112

Forum:
Excel Programming / VBA / Macros
Copy Paste Conditional Formatting

Started by gwflyer‎, 03-10-2016 04:31 PM
- 1
- 1,382
Last Post By:

Last Post: 03-10-2016 05:34 PM

by JBeaucaire

Forum:
Excel Programming / VBA / Macros
[SOLVED] VBA code to copy worksheet and paste as values

Started by TheTrueVince‎, 02-05-2016 07:42 AM
- 5
- 1,045
Last Post By:

Last Post: 02-05-2016 11:08 AM

by Alf

Forum:
Excel Programming / VBA / Macros
Runtime error 1004 @ every 2nd run @ pastespecial

Started by BlauePflanze‎, 10-21-2014 03:55 AM
- 0
- 748
Last Post By:

Last Post: 10-21-2014 03:55 AM

by BlauePflanze

Forum:
Excel General
Copy Data outside Excel and PasteSpecial inside Worksheet - Run-time error '1004'

Started by deisouss‎, 09-04-2014 10:18 AM
- 7
- 2,573
Last Post By:

Last Post: 03-17-2021 02:27 AM

by FDibbins

Forum:
Excel Programming / VBA / Macros
VBA copy paste between two books. 1004 error PasteSpecial method

Started by fukirua‎, 07-29-2014 06:27 PM
- 3
- 1,074
Last Post By:

Last Post: 08-04-2014 07:41 PM

by fukirua

Forum:
Excel Programming / VBA / Macros
PasteSpecial from a Batch Code failed

Started by superdonk‎, 07-28-2014 09:37 AM
- 3
- 843
Last Post By:

Last Post: 07-28-2014 10:47 AM

by AB33

Forum:
Excel Programming / VBA / Macros
Problem Pasting with VBA

Started by chicagoland8‎, 04-14-2014 01:58 PM
- 2
- 691
Last Post By:

Last Post: 04-14-2014 02:17 PM

by AB33

Forum:
Excel Programming / VBA / Macros
[SOLVED] How to paste picture into cell without cell selection?

Started by tahi.laci‎, 02-02-2014 05:39 PM
- 3
- 769
Last Post By:

Last Post: 02-03-2014 08:06 AM

by 6StringJazzer

Forum:
Excel Programming / VBA / Macros
VBA PasteSpecial to append

Started by ch_abs‎, 01-23-2014 10:39 AM
- 0
- 691
Last Post By:

Last Post: 01-23-2014 10:39 AM

by ch_abs

Forum:
Excel Programming / VBA / Macros
[SOLVED] PasteSpecial method of Range class failed

Started by lottidotti‎, 08-27-2013 12:57 AM
- 2
- 908
Last Post By:

Last Post: 09-08-2013 08:21 AM

by lottidotti

Forum:
Excel Programming / VBA / Macros
PastSpecial overwrites where I want to append

Started by Purpose‎, 05-12-2013 08:36 AM
- 6
- 932
Last Post By:

Last Post: 05-16-2013 04:26 AM

by AB33

Forum:
Excel Programming / VBA / Macros
Paste Formats causes uneeded recalc

Started by eshadd‎, 11-23-2012 07:02 AM
- 0
- 530
Last Post By:

Last Post: 11-23-2012 07:02 AM

by eshadd

Forum:
Excel Programming / VBA / Macros
Excel hanging/crashing when closed

Started by NJG‎, 10-18-2012 09:43 PM
- 0
- 771
Last Post By:

Last Post: 10-18-2012 09:43 PM

by NJG

Forum:
Excel Programming / VBA / Macros
Macro: Acces of PasteSpecial method of the worksheet class

Started by stenseth‎, 09-03-2012 07:17 AM
- 0
- 600
Last Post By:

Last Post: 09-03-2012 07:17 AM

by stenseth

Forum:
Excel Programming / VBA / Macros
[SOLVED] Pasting multiple ranges as Bitmaps into Word + Editing them

Started by jmfenn‎, 07-23-2012 06:59 PM
- 1
- 1,596
Last Post By:

Last Post: 07-24-2012 04:31 PM

by jmfenn

Forum:
Excel Programming / VBA / Macros
Sort

Started by dpalm‎, 02-15-2012 12:55 PM
- 5
- 856
Last Post By:

Last Post: 02-17-2012 09:34 AM

by dpalm

Forum:
Excel Programming / VBA / Macros
Copy Range ("C7:C20") PasteSpecial to another sheet in next available row A:N Help

Started by dpalm‎, 02-13-2012 03:21 PM
- 2
- 1,047
Last Post By:

Last Post: 02-14-2012 08:45 AM

by dpalm

Forum:
Excel Programming / VBA / Macros
Can't Check / Uncheck Chechbox based on Cell value because of PasteSpecial

Started by Saramara‎, 12-27-2011 10:55 AM
- 8
- 1,264
Last Post By:

Last Post: 12-29-2011 09:13 AM

by Saramara

Forum:
Excel Programming / VBA / Macros
Conditional Formatting out of order after PasteSpecial

Started by yjbrody‎, 12-02-2010 01:11 PM
- 1
- 1,058
Last Post By:

Last Post: 12-02-2010 01:29 PM

by TMS

Forum:
Excel Programming / VBA / Macros

Results 1 to 31 of 31

Search: Replies Views Search took 0.00 seconds.

[SOLVED] PasteSpecial xlPasteValues Compile Error

[SOLVED] Intermittent Runtime error 1004 Paste Method of worksheet class failed

[SOLVED] how do I paste data as values

[SOLVED] Create a keyboard shortcut through Macro in order to copy paste special (divide)

[SOLVED] Problem Copying between two workbook with ribbon toolbars disabled

[SOLVED] VBA PasteSpecial Named Range - Cannot change part of a merged cell

[SOLVED] VBA code to copy worksheet and paste as values

[SOLVED] How to paste picture into cell without cell selection?

[SOLVED] PasteSpecial method of Range class failed

[SOLVED] Pasting multiple ranges as Bitmaps into Word + Editing them