LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Get a range of cells from a selection of Rows

Thanks, David. Appreciate it.

"David McRitchie" wrote:

Hi Dan,
You would have to paste into a single cell in Column A,
and the out receiving range would be expanded accordingly.
You would have to paste to Column A because that is the
only way the number of columns will match.

"danhattan" wrote...
My subject line may have caused confusion. It should have read "selection of
Rows".

Because my code captures entire rows, all the way from column A to column
IV, I can't paste into a range of cells. I have to paste into a corresponding
number of selected rows. Thus my dilemma. Sorry about the typo in the subject
line, and thanks for looking at it. That said, any additional thoughts on how
to change the selection of entire rows to just a range of columns within the
entire row?







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
need to save values from a range of cells based on selection from list vhrao Excel Programming 1 July 19th 06 02:49 AM
creation of name range without selection of cells Jim at Eagle Excel Programming 2 June 16th 06 08:23 PM
duplicate listbox selection to range of cells? lozc Excel Programming 4 February 9th 06 01:02 AM
random selection from a range of cells tjb Excel Worksheet Functions 1 February 15th 05 06:34 PM
Excel - Copy range of cells based on Combobox Selection Excel-erate2004 Excel Programming 2 April 3rd 04 05:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"