Select the same cell in sheets 2 & sheets 3
 

Hi, I am after a code to select the same cell that is activated in
sheets 1 to select the same cell in sheets 2 & sheets 3. The cell that
is selected is determined by a listbox on a form, therefore it will
always vary but the column is always the same. Once i have this i will
then be able to get my macro to write to all the sheets various
infomation in the same row!

Thanks in advance