Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Simon, I only what to search in one column which is "I". Then if "E" or "M" i found in that column then I want to Select columns "A to G" in that sam row. But I want to do this to the entire sheet with one click becaus there are multiple instances within a workbook. I thought of using a I statement and narrow the search only to column "I". Thanks for th help. Scot -- ----------------------------------------------------------------------- 's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=27684 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Hi Scott;
This should do it: Sub try() HomeSheet = ActiveSheet.Name 'Go to Sheet2 and prepare it to receive the coping Sheets("Sheet2").Select Range("A1").Select 'Go back to the original sheet Sheets(HomeSheet).Select Range("I1").Select While Not ActiveCell = "" If ActiveCell = "E" Or ActiveCell = "M" Then Range(Cells(ActiveCell.Row, 1), Cells (ActiveCell.Row, 7)).Copy Sheets("Sheet2").Select ActiveSheet.Paste Application.CutCopyMode = False Sheets(HomeSheet).Select End If ActiveCell.Offset(1, 0).Select Wend End Sub Thanks, Greg -----Original Message----- Simon, I only what to search in one column which is "I". Then if "E" or "M" is found in that column then I want to Select columns "A to G" in that same row. But I want to do this to the entire sheet with one click because there are multiple instances within a workbook. I thought of using a IF statement and narrow the search only to column "I". Thanks for the help. Scott -- ---------------------------------------------------------- -------------- 's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=16279 View this thread: http://www.excelforum.com/showthread...hreadid=276840 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |