+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Jul 2007
    Location
    Burnley and Barnoldswick
    Posts
    1
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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:

    Range("c33:d33").Select
    Selection.Copy
    Sheets("examples2").Select
    Range("B3:C3").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.Insert Shift:=xlDown


    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.

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    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

  3. Thanks to penfold_99 from:

    cursong (13th October 2008)

SHARE:
+ Post New Thread

Similar Threads

  1. Looping with range in VBA, help please
    By iuppiter in forum Coding
    Replies: 2
    Last Post: 8th September 2008, 03:47 PM
  2. Excel VBA Loop Question
    By vunsev in forum Coding
    Replies: 5
    Last Post: 11th April 2008, 08:08 AM
  3. problems opening excel document
    By PEO in forum How do you do....it?
    Replies: 6
    Last Post: 7th March 2008, 09:53 AM
  4. Excel
    By Edu-IT in forum How do you do....it?
    Replies: 13
    Last Post: 7th March 2008, 08:57 AM
  5. Macro and VBA functions
    By randle in forum Windows
    Replies: 10
    Last Post: 9th February 2007, 09:32 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •