select entire row from a lookup
"Rick Rothstein" wrote:
What is in the dropdown?
it is a dropdown from a list
Your subject line mentioned "lookup"... are you
trying to lookup what the user picked? Is so, where did you want to look
at... a column, a row, a range of cells?
The list is "looking" at a column.
You mention that you want to select
and then copy... odds are you do not have to select to do your copy, but to
know for sure, you need to tell us about your "customizable list". Where
and/or what is it... an array in memory, a String variable,
a range of cells, the row of which the lookup column selected cell is
located
something else? The more details you tells us, the better answer one
of us will be able to provide for you.
--
Rick (MVP - Excel)
"JR" wrote in message
...
I need to allow users to make a selection from a dropdown then I want code
to
select the entire row (in this instance A throuhg J), copy the row and
paste
it into a customizable list.
Can anyone tell me how to select an entire row in that manner?
Thanks.
|