+ Reply to Thread
Results 1 to 5 of 5

1004 on Rows("1:10").Select

  1. 06-04-2020, 11:12 AM #1
    Gabor
    Gabor is offline
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    1004 on Rows("1:10").Select

    I get run-time error 1004, on this very simple code:
    Please Login or Register  to view this content.
    Tried lots, none works. Have no clue this time, what it might be. xl2016.
    Regards,

    Gabor

    Protect trees.. maybe one day we need to climb back....
    Reply With QuoteRegister To Reply
  2. 06-04-2020, 11:23 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: 1004 on Rows("1:10").Select 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 06-04-2020, 11:24 AM #3
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: 1004 on Rows("1:10").Select

    It works for me although I don't see why this line of code is necessary:
    Please Login or Register  to view this content.
    It doesn't seem to serve any purpose.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  4. 06-04-2020, 11:34 AM #4
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: 1004 on Rows("1:10").Select


    Hi,

    in fact none is necessary as any good code at 99.999% does not need to select anything …
    Reply With QuoteRegister To Reply
  5. 06-04-2020, 11:58 AM #5
    Gabor
    Gabor is offline
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    Re: 1004 on Rows("1:10").Select

    sorry, I got it wrong: the code was on a worksheet module.
    As soon as I moved over to a module it started working...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro doesn't correctly replace "." with "," and getting Run-time error '1004'.
    By H.Gabor in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-26-2018, 06:36 AM
  2. [SOLVED] RunTIme Error 1004 when asked to select ".range"
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2018, 07:55 AM
  3. "Countif" with "left" error, "Sumproduct" picking up not qualifying rows
    By drgkt in forum Excel General
    Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  4. range("e1" & cells(rows.Count,5).end(xlup)).Select
    By sohaila in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2014, 09:27 AM
  5. [SOLVED] Hide/unhide excel rows as per answer i.e. "Yes", "No", "Not Applicable"
    By jaysakle in forum Excel General
    Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  6. code to replace 'Rows("31:31").Select' statement with variables
    By Ed_Collins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2012, 06:28 PM
  7. Excel VBA Runtime error 1004 "Select method of Range class failed"
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2012, 10:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1