| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VBA to find a value and select a range
I am trying to write a macro that will let me find a specific vale in a
specific column, then select part of the row that the value is in, beginnign with a column 31 cells away from the column that the specific value is in. Someone suggested to me that I use an IF statement, but this is all I know about that: IF [value in column B] is €śGrand Total€ť Then select from column AF to the end of the array in that row and copy it and paste a transpose of the values starting in cell I9 of worksheet X. What is the best way for me to accomplish this goal? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| find & select | Excel Worksheet Functions | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| select date range then find average of values in another cell | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Threaded Mode
