Thread: VBA Novice having problems with colours.
View Single Post
 
Old 02-29-2012, 03:28 AM
Simoninparis Simoninparis is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Feb 2012
Posts: 4
Simoninparis is on a distinguished road
Default here's the code
Code:
    
Worksheets("Agent").Cells(8, 2) = Feuil1.Cells(8, AgCol)
Maj(8, 2) = 8
Yes, part of the code is in French and part in English - this doesn't seem to affect the functionality.

"Feuil1" is the worksheet with all the data, The worksheet called agent is where I want the data to display. "Maj" is an array used to transfer up and down between the sheets.

Does this shed any light on the matter?
Reply With Quote