why is copy and paste so tricky with vba?

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,799
Office Version
2013
Platform
Windows
@ajm....so it works now ???
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,748
@ajm....so it works now ???
sorry Michael. Yes it does. I have to do some reading (in all my spare time!....) on the when to use what with copy and paste. Its my achilles heel for some reason. thanks all for your help.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,799
Office Version
2013
Platform
Windows
yeah, I agree copy / paste special.....always used to do my head in....(y)
 

Watch MrExcel Video

Forum statistics

Threads
1,096,312
Messages
5,449,617
Members
405,573
Latest member
Masimo85

This Week's Hot Topics

Top