View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lost in Chicago[_2_] lost in Chicago[_2_] is offline
external usenet poster
 
Posts: 6
Default genius wanted VBS

Got this to work but it wont let me copy and paste rows or coumns need to
exclude then from the VBS any ideas?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Size = 10
Cells.Interior.ColorIndex = 0
Target.Font.Size = 14
Target.Interior.ColorIndex = 24
End Sub