Coding Thread, Excel VBA problems in Coding and Web Development; When trying to run the following piece of code I get a runtime '1004' error, select method of range class ...
13th October 2008, 12:16 PM #1
- Rep Power
Excel VBA problems
When trying to run the following piece of code I get a runtime '1004' error, select method of range class failed.
I am trying to copy a selection of data from one sheet to anoher sheet and then moe the row down.
The code I have is as follows:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Application.CutCopyMode = False
It keeps falling over at the section in bold, if anyone has any answers, much appreciated thanks. Have looked fro other solutions on other websites but doesnt seem to help.
IDG Tech News
13th October 2008, 12:28 PM #2
Are you trying to copy a value form one field to another?
if so try
Sheets("examples2").Range("B3").Select = _
Sheets("WHAT EVER THIS CALLED").Range("C33").value
Sheets("examples2").Range("C3").Select = _
Sheets("WHAT EVER THIS CALLED").Range("D33").value
Thanks to penfold_99 from:
cursong (13th October 2008)
By iuppiter in forum Coding
Last Post: 8th September 2008, 04:47 PM
By vunsev in forum Coding
Last Post: 11th April 2008, 09:08 AM
By PEO in forum How do you do....it?
Last Post: 7th March 2008, 10:53 AM
By Edu-IT in forum How do you do....it?
Last Post: 7th March 2008, 09:57 AM
By randle in forum Windows
Last Post: 9th February 2007, 10:32 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread