Is there any way that 'filling' can be restricted to values only and not formatting, perhaps through VBA?

[Rnkhch]

Hello,

I know that it is possible to right-click and drag and then select 'fill without formatting', but is there any formatting changes can be disabled for dragging/filling, perhaps through a VBA code?

Thanks for any input!

 

[Rnkhch]

Thanks! I'll totally take you out for a drink if you're in LA area lol

 

[johnnyL]

Hmm, It worked fine for me. I copied R17:S18 to E18 and it worked fine.

Are you sure you replaced the entire old code with the entire new code?

 

[Rnkhch]

Control+V works fine, but paste values leads to automatic clearing. (Yes, I completely deleted the old code and pasted the new code)

 

[johnnyL]

This is what I did, I selected R17:S18, right clicked, selected copy, selected E18, right clicked & selected paste.

 

[johnnyL]

CTRL+C & CTRL+V also worked fine.

 

[Rnkhch]

By 'paste values' I mean the paste special for which I have defined a button in the quick access toolbar. It's the button that has a 123 on it.

In the paste menu, it is the first button under "paste values'

 

[johnnyL]

I can't be responsible for any buttons you have made.

 

[Rnkhch]

Well it's the same as the one in the paste menu. It's not just my button. (that's just for quick access)

The standard paste menu has the "paste values" button".

 

[johnnyL]

The code handles how the pastes should be done, that is probably the issue.

 

[Rnkhch]

Yes, I described the "regular paste" (control+V) issues under item A in my post #67.

B and C are for "paste values".