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

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

From: RobFMS (Rob_at__xIgnoreThisx_fmsinc.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 08:56:21 -0400

Try:

ActiveSheet.Range(Range).EntireRow.Select

Where Range is a cell address on the row you want to select.
If row 3 is what you wanted selected, then range can be set as "A3", "D3",
etc.

HTH 

-- 
Rob
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"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.
    ... "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: What is the Visual Basic command to select an entire row in Excel.
    ... You can use this for the activecell row ... > 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 ... 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)