View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard_123 Richard_123 is offline
external usenet poster
 
Posts: 7
Default Go to a given row number

Hello,

In a cell I have a number, which can change. Say it was 75. I then want to
copy the value off one sheet in, say cell A1, and paste it into cell G75 on
another sheet.

I'd like to be able to do this with a macro, so that if the number 75
changes to 30, it will copy cell A1 into cell G30 instead.

Is this possible?

Thanks,
Richard