Posted to microsoft.public.excel.programming

dch3

external usenet poster

Posts: 15

Referencing Cells in a Selected Row

I need to obtain the value in several cells from a row selected by the user.
What is the syntax that I should use to pull the values from the selected
row?

Dim sel As Range
Set sel = Application.Selection
sel.Cells(sel.row,1)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referencing selected cells	[email protected]	Excel Worksheet Functions	2	September 27th 06 07:22 PM
Referencing the First Cell in Any Selected Range	maximouse	Excel Programming	4	November 1st 05 03:57 AM
Referencing a Column in a Selected Range of Columns	Rob G	Excel Programming	3	October 21st 04 05:21 PM
referencing previously selected cells after macro execution begins	Glenn	Excel Programming	5	October 15th 04 12:52 AM
referencing values in adjacent cells to selected cell	Darren Haslett	Excel Programming	3	February 23rd 04 05:45 PM

All times are GMT +1. The time now is 07:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us