Quote Originally Posted by Shijesh Kumar View Post
Its just a part of code to give you a direction... 

dim source_row as integer

dim target_row as integer
dim col as integer

source_row =77
target_row = 26
col = 3


tempValue = ComboBox1.value
if tempValue ="Jan 09" then
   range( source_row , col) = range( target_row , col)               col = col+1
end if
Hi and Thank you

I'm getting an error with this part of the code in red when I pick "Jan 09" in the combo box. The error is method Range of object_worksheet failed?

Thank You, Mike