Macro that copies values from column A (from formula) to B (paste value)

[AA Arens]

I am looking for a VB code (for a command button) that copies values of column A (fixed range A1 - A100, contains values from a formula) to column B (B1 - B100, paste special: value).t the

After that, the focus (active cell) is back to A1.

Thank you, Bart

 

[GS]

AA Arens was thinking very hard :

I am looking for a VB code (for a command button) that copies values of
column A (fixed range A1 - A100, contains values from a formula) to column B
(B1 - B100, paste special: value).t the

After that, the focus (active cell) is back to A1.

Thank you, Bart

Sub CopyValues_AtoB()
Range("$B$1:$B$100").Value = Range("$A$1:$A$100").Value
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion