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

A

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top