Thread: Need a macro
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Need a macro

Thanks for jump-in David.

Seems pcor is now happy so operation complete.


Gord

On Wed, 6 Sep 2006 13:00:03 -0400, "David McRitchie"
wrote:

Change the line of code
cCols = InputBox("Original Number of Columns")

to
cCols = 2
but I would really recommend the following if column 3 is empty
cCols = 3