Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS
On Thu, 12/21/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
On Thu, 12/21/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Th

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS
On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wed

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS
On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wednesday, December 20, 2017, 1:56 AM

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-19 Thread David Lanman
How about simply copy and paste values and do it to the the whole sheet? Sub CopyPastVal() Cells.Copy Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub Thanks, David On Tue, Dec 19, 2017 at 3:31 PM,