Thanks Dave
Has worked a charm! I have formatted the cells that data shall be
placed into (via macro) in advance, so should not be a problem in the
future.
Thank you kindly once again!
On Oct 23, 5:28 pm, Dave Bonallack <[EMAIL PROTECTED]> wrote:
> Hi,
> Just formatting a cell as number after t
Hi All
I'm trying to code a worksheet so that when I press a button, it sorts
the column in numerical order. I have been using the code
Private Sub commandbutton12_click()
Range("A71:U1000").Select
Selection.Sort Key1:=Range("A71"), Order1:=xlAscending,
Header:=xlNo, _
OrderCustom:=1
