Re: What is the Visual Basic command to select an entire row in Excel.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ron de Bruin (rondebruin_at_kabelfoon.nl)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 14:55:34 +0200

Hi Sahja

You can use this for the activecell row
ActiveCell.EntireRow.Select

Or this for row 15
Range("A15").EntireRow.Select 

-- 
Regards Ron de Bruin
http://www.rondebruin.nl
"Sahja" <Sahja@discussions.microsoft.com> wrote in message news:5DE03FD6-55DA-4C85-9D80-96BA878195D1@microsoft.com...
> When I use the command Rows.EntireRow.Select in Visual Basic to select a
> single row in an Excel spreadsheet it selects all the rows in the
> spreadsheet.   Is there another command that will select a single row??

Relevant Pages

  • Re: What is the Visual Basic command to select an entire row in Excel.
    ... Where Range is a cell address on the row you want to select. ... > single row in an Excel spreadsheet it selects all the rows in the ... Is there another command that will select a single row?? ...
    (microsoft.public.excel.programming)
  • Re: What is the Visual Basic command to select an entire row in Excel.
    ... "Sahja" wrote in message ... > single row in an Excel spreadsheet it selects all the rows in the ... Is there another command that will select a single row?? ...
    (microsoft.public.excel.programming)
  • Re: DSAdd Users Multiple Users
    ... error when i tried to run the vbs. ... I have written VBScripts that pull from an Excel Spreadsheet. ... When I type this command, it completes correctly and the user is ...
    (microsoft.public.windows.server.active_directory)
  • Re: extra index scans on update
    ... Perhaps datatype of colx and x are different. ... Only a single row is updated for each ... > If I run the same command again, it works much faster because there are ... When I run the same command again, the row is in the cache and things ...
    (microsoft.public.sqlserver.programming)
  • Reversing Dates on First Insert in DataEnvironment and VB6
    ... I am using a Command to INSERT a single row INTO an Access table. ... Date/Time fields are causing me grief by reversing the Day and Month - but ... Dim dtEnd As Date ...
    (microsoft.public.vstudio.development)