Pattern Not Applying to Cells

szymagic

Board Regular
Joined
Jul 8, 2016
Messages
61
Hey All,

So a friend of mine has a workbook that is acting up.

When he selects a range to fill the cells he has to click twice. The first time he clicks nothing happens, and the second time he clicks the pattern is applied.

I thought this was curious so I recorded a macro when he did this and this is what we got:

Code:
    Range("A82:G82").Select
    With Selection.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = [COLOR=blue]5296274[/COLOR]
        .TintAndShade = 0
        .PatternTintAndShade = 0
For some reason the first time he clicks the fill button, excel recognizes it as .Pattern = xlNone

I think that is super weird. He is working in Office 365 32 bit. Any ideas on what is happening?

I checked conditional formatting and protections and there was nothing there for either. This is also an xlsx.


Thanks so much!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,294
Office Version
2013
Platform
Windows
The first time he clicks nothing happens
Clicks what ??
Is this part of a larger code ??


Code:
With Range("A82:G82").Interior
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    .Color = 5296274
    .TintAndShade = 0
    .PatternTintAndShade = 0
End With
 

szymagic

Board Regular
Joined
Jul 8, 2016
Messages
61
Like when you click the fill cell "bucket" he has to click twice. The code was just to see what was actually happening per click.

The code doesn't do anything, and this really isn't a VBA related question, I'm just using VBA to tell a piece of the story!

Thanks
 

Forum statistics

Threads
1,085,301
Messages
5,382,808
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top