I am trying to scan every row in Column A for this symbol * , when this symbol * is found I’d like the macro to copy the row and perform a paste special / values for the row that the * was found in.
This is what I have so far but I am kind of stuck, if you could lend a hand i would appreciate the help. Thanks
Please Login or Register to view this content.
Last edited by Racer; 03-11-2010 at 07:26 PM. Reason: SOLVED
Racer ,Originally Posted by Racer
I am trying to scan every row in Column A for this symbol * , when this symbol * is found I’d like the macro to copy the row and perform a paste special / values for the row that the * was found in.
This is what I have so far but I am kind of stuck, if you could lend a hand i would appreciate the help. Thanks
Please Login or Register to view this content.
Leave out the "?" in the Range("A?".........
[/QUOTE]Please Login or Register to view this content.
Marmo,
will copy the entire Column. I believe the row is required.Please Login or Register to view this content.
Try this codePlease Login or Register to view this content.
Last edited by rwgrietveld; 03-10-2010 at 05:07 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thank you rwgrietveld this macro accomplishes what I was trying to do. Thank you for the help. I appreciate it very much.
Thank you for the input MarMo.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks