Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
Seriously in my opinioin, for £35 you may aswell throw it down the drain. I wouldn't even detail a car without polishing it for £35. Machine polishing is a big job and it requires a lot of skill and patience, I learn something new everytime I do it.
Secondly, if he's doing it for £35 it's not...
Call me pedantic, but you can polish something without correcting paintwork.
;)
I'm out of the detailing scene now anyway. All my detailing stuff was stolen out the garage the other week. I'm going to pay someone to do it from now on. Not NW Valet though.
FPMSL, no thanks i'd rather take it to the polish.
Would never trust a car cleaning business that had "Valet" in their trading name either. The proper boys know it's called "Detailing".
I got my 182 at 19 but didn't crash it into a bush.
Saying that I also didn't go doing 110mph down a country lane; nor did I pay 4k for tpft insurance flol
Done it. I had to dimension a variable and add a few more lines.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCell As Range
Set KeyCell = Range("F10")
If Not Application.Intersect(KeyCell, Range(Target.Address)) Is Nothing Then
If KeyCell.Value...
Yes it needs to be programmed into the VBE. You cannot record it.
It's frustrating because I can do most things in the VBE, but i've never used the worksheet Change event procedure, and im not sure of the parameters i need to set for what I want to do in this case.
You have gone up in my estimations symondo!
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a1") = "QVN" Then
Rows("5:7").Select
Selection.EntireRow.Hidden = True
Range("A1").Select
Else
Rows("5:7").Select
Selection.EntireRow.Hidden = False...
If so would you mind PMing me your e-mail address so I can pick your brains?
In short i'm wanting a macro to activate as soon as a certain value is celected.
IE if cell a1 = 1 I want the code i've wrote to run.
Thanks :)
LOL!
His cars broke and he wants it fixed. Thats like me posting in a thread someone started due to a failed cambelt:
"It's ok if your cambelts failed, just use the bus".