Copy RngFrm in workbook A to RngTo in workbook B.
RngFrm and RngTo are from InputBoxes.
RngFrm.Copy RngTo
All this works just fine.
Want to add the PasteSpecial.Values because RngFrm is formulas and I
want RngTo as values only.
I've tried With RngTo / End With but cannot get the proper syntax
PasteSpecial in without errors.
Thanks.
Howard
Just assign the value directly...
RngTo = RngFrm
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion