Macro Help
This is my scenario: I’m using Excel 2003 and I need a macro to find a character in a colum (I) and then if its found select columns (A to G) in that same row. need to repeat this for all instances within the workbook. Th character in column (I) will always be a single character such as E o M. Basically, I want to copy the selected cells and copy them int word. Please help if someone can. Scot -- ----------------------------------------------------------------------- 's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=27684 |
Macro Help
Hi, This code will find and select all rows that contain M it will o course find the first row that contains the letter m, im not sure ho to get it to find only the row that contains a single character, hop this gets you a little closer! Simon Dim rng As Range Dim what As String what = "M" Set rng = ActiveSheet.UsedRange.Find(what) Rows(rng.Row).selec -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=27684 |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com