Return to Question

##Objective of Code

##Problem

Objective of Code

Problem

The problem is my spreadsheet is now intolerably slow.

Is there a way to speed things up?

The problem is my spreadsheet is now intolerably slow. Note, the WS is quite large, with ~1000 rows X 82 columns.

Is there a way to speed things up?

EDIT

I have three additional Private Subs at the top of my code. Not sure that's relevant, but it was suggested that I inlcude everything.

Private Sub CommandButton1_Click()
Range("U5:U961").Value = Range("T5:T961").Value
End Sub
Private Sub CommandButton2_Click()
Range("W5:W961").Value = Range("V5:V961").Value
End Sub
Private Sub CommandButton3_Click()
Range("Y5:Y961").Value = Range("X5:X961").Value
End Sub

The code of interest starts from here.

Note: Question originally asked in SO, here

Objective of Code

To solve this, I have created VBA code that highlights the relevent cell in the relevant column for comparison. So for example, if I click on cell O5, cell J5 will be highlighted. When I click away, J5 returns to its original format.

By highlight, I mean specifically the cell text becomes white, bigger and is enboldened.

Problem

The code below achieves exactly allt this. (Note, the basis of my code comes from the generous help of Tim Williams in a previous question).

Note: Question originally asked in SO .

##Objective of Code

To solve this, I have created VBA code that highlights the relevant cell in the relevant column for comparison. So for example, if I click on cell O5, cell J5 will be highlighted. When I click away, J5 returns to its original format.

By highlight, I mean specifically the cell text becomes white, bigger and is emboldened.

##Problem

The code below achieves exactly all this. (Note, the basis of my code comes from the generous help of Tim Williams in a previous question).