Displaying Code On A Thread

[AidanDanby]

Hi Everyone,

How do I display code within a thread? I need some help with a bit of code that sorts data in sheets in a spreadsheet

Thanks,

Aidan

 

[RoryA]

Enclose it in code tags - see my signature below.

 

[AidanDanby]

Thankyou Rory,

Could you possibly help me on an issue from a thread I started on 15th May 'Vlookup Question' #15

The code I need adapting as described is:

 With ActiveWorkbook.ActiveSheet
  .Range("A2:S957").Sort key1:=.Range("Q2"), order1:=1, key2:=.Range("R2"), order2:=1
  .Range("A2").Select

The code is run using CTRL + SHIFT + Y and only sorts the sheet that is active at the time in the workbook (there is a sheet for each day of the month)

Thankyou,

Aidan

 

[RoryA]

I added a reply to the original thread. (it doesn't really belong in this one)