What does iWs mean?
Also, is if I want the data to go into a sheet called 'Reports', where would I write this?
Many thanks
Link to old thread - http://www.excelforum.com/excel-prog...ate-range.html
What does iWs mean?
Also, is if I want the data to go into a sheet called 'Reports', where would I write this?
Many thanks
Link to old thread - http://www.excelforum.com/excel-prog...ate-range.html
Last edited by arlu1201; 08-26-2013 at 04:42 AM.
Also, will this work in MS Excel 2010? I am trying to work out why it won't work for me.
The above code is looping through all the sheets in the workbook. If you want to select only a particular sheet, you will need to change the code a bit. Do you want to use the same code as above except that it should work only in 1 sheet?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes please - I need it to search a sheet called 'Data' and put found rows in a sheet called 'Reports' within the same Excel 2010 workbook.
Last edited by Tim Newton; 08-26-2013 at 02:51 AM. Reason: Minor error
Try this
Please Login or Register to view this content.
It is coming up with a bug in the last line:
Worksheets("Data").Range("A2:P" & lrow).Copy Worksheets("Report").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
What is the error you are getting?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks