Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with 1 code line
Hi JMay,
My addition of "Color" should have been ColorIndex! --- Regards, Norman "Norman Jones" wrote in message news:... Hi JMay, Without otherwise looking at your event procedure, your problem code line should read: ActiveSheet.Range("B4").CurrentRegion.Rows.Interio r.Color = xlColorIndexNone --- Regards, Norman "JMay" wrote in message news:M6Ewc.10402$ye1.1834@lakeread05... Below code in Sheet2 allows user to return to previous clicked cell in Sheet1: My Sheet1 code (not shown) Highlights ActiveRow (on Sheet2) setting interior = 3. 4th line of code below is my attempt to remove colorindex when retuning to sheet1, however it "ain't-working". Any help appreciated. TIA, Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Excel.Range, Cancel As Boolean) If Not Intersect(Target, Range("B:B").EntireColumn) Is Nothing Then Cancel = True Application.Goto Reference:=Application.PreviousSelections(1) ActiveSheet.Range("B4").CurrentRegion.Rows.Interio r = xlColorIndexNone <<BOMB!! End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
code line with two conditions | Excel Discussion (Misc queries) | |||
Help with 1 code line | Excel Programming | |||
One line of code messed up! | Excel Programming | |||
Same code, different line | Excel Programming |