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.
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 done to the row involved.
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 >
>
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 case 462) using Colu
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 number
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 sa
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
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
End
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 basic
knowledge of VBA
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
.
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
.
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.
LabVIE
12 matches
Mail list logo
