Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Paul Sir, Good Morning. Thank you so much for your code, for the effort and time dedicated.And your explanation is too good but bcos of less understanding VBA coding I cant get all information but any way i sort out my issue.Currently i Use Excel 2003 & future planning to work on excel 2007.

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

Here is the file you request. thanks On Sat, Nov 5, 2016 at 12:25 AM, Paul Schreiner wrote: > Yes, it could be done with an IF() function, > but that would have to be duplicated and it would execute in each row > whenever changes are made. > Even if the changes were not

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

Thank you Ashish it works perfectly. I will save this info so I don't repeat my question in the future. Much appreciated. -- John On Friday, November 4, 2016 at 4:08:49 PM UTC-4, ashish wrote: > try > > Range("A" & bottom & ":M" & bottom).Select > > On Sat, Nov 5, 2016 at 1:34 AM, Johnny

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

try Range("A" & bottom & ":M" & bottom).Select On Sat, Nov 5, 2016 at 1:34 AM, Johnny wrote: > I searched for the answer to this before posting. I know what I'm trying > to do can work, it's just that the syntax is kicking my butt > > I find the bottom row number (in my

$$Excel-Macros$$ Help with Proper Syntax for Range function with variables

I searched for the answer to this before posting. I know what I'm trying to do can work, it's just that the syntax is kicking my butt I find the bottom row number (in my case 462) using Column E in this example, and I'd like to select the Range from Column A to Column M with that row

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

Yes, it could be done with an IF() function,but that would have to be duplicated and it would execute in each row whenever changes are made.Even if the changes were not done to the row involved. We can make a Change event so that whenever a cell is changed, it evaluates the other cells in the

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

Hi Paul thanks thanks thanks a lot. the code is working well now. my problem is solved now but i need another help here how to make COLUMN V automatic turn to ''PASSED" when COLUMN AC to AH is all passed and automatic turn to ''FAILED" when one of the COLUMN AC to AH got one failed. please

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

 Is this what you're looking for? For Each Rng In Range("AC3:AH30")     If (Rng.Value = "Failed") Then     If (Not Rng.EntireRow.Hidden) Then     With Rng.Interior    .Pattern = xlNone     .TintAndShade = 0     .PatternTintAndShade = 0    

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

 See answers below: On Friday, November 4, 2016 2:00 AM, amar takale wrote: Dear Paul Sir, This is fabulous work! I think this must be flashing on the front page! :D. And I am Extremely sorry for so late reply bcos of diwali vacation. I am VBA learner so only

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

Hi paul these is two code u gave to me. I try to combine it but come out with error. Please help to arrange these 2 code Private Sub CommandButton1_Click() Dim rng As Range For Each rng In Range("AC3:AH30") If (rng.Value = "Failed") Then With rng.Interior

Re: $$Excel-Macros$$ Excel active x control command button to duplicate text in entire row and column?

Hi paul these is two code u gave to me. I try to combine it but come out with error. Please help to arrange these 2 code Private Sub CommandButton1_Click() Dim rng As Range For Each rng In Range("AC3:AH30") If (rng.Value = "Failed") Then With rng.Interior

$$Excel-Macros$$ LabVIEW Training : Free Demo Classes

Learn the recommended techniques to reduce development time and improve application performance and scalability. LabVIEW courses are available in several formats to fit your needs, including instructor-led in the classroom, instructor-led online, on-site at your location, and self-paced.

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Paul Sir, This is fabulous work! I think this must be flashing on the front page! :D. And I am Extremely sorry for so late reply bcos of diwali vacation. I am VBA learner so only basic knowledge of VBA coding. I have some Question here: 1) Can I use this code in excel 2007 after giving