Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a value then select that column
I am working on a project where I need to find a value in a cell within a table (I use vlookup to do this). Once that value is found is there a way to make that entire column active, so as I may then use a macro to copy and print values of the active column? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a value then select that column
If you're using =Vlookup(), doesn't that mean you know what column you want?
Did you mean Row instead of one of those columns? (If yes, which one?) Sevcav wrote: I am working on a project where I need to find a value in a cell within a table (I use vlookup to do this). Once that value is found is there a way to make that entire column active, so as I may then use a macro to copy and print values of the active column? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Find & Select | Excel Discussion (Misc queries) | |||
SELECT ALL ROWS IF FIND | Excel Discussion (Misc queries) | |||
select row if find word | Excel Discussion (Misc queries) | |||
find & select | Excel Worksheet Functions |