TheSwamp

Code Red => VB(A) => Topic started by: davidratx on October 12, 2015, 12:43:21 PM

Title: Excel Search Data and Save String
Post by: davidratx on October 12, 2015, 12:43:21 PM

I want to search for Text in the an Excel file and update the Row text style, color etc etc

I have having a hard time defining the Range.

For example, I want to search "Purchase Length" and update that row, Purchase Length will remain the same, but the row location will change.

I am a novice, we generate these files automatically, I am attempting to automate the cleanup process.

Title: Re: Excel Search Data and Save String
Post by: Matt__W on October 12, 2015, 03:53:47 PM

Check out this link...
http://www.mrexcel.com/forum/excel-questions/47056-find-text-select-row.html