Thread: offset problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 122
Default offset problems

Hi,
I have a button on my userform called "save"

if clicked i would like to save some info on another sheet.

1. The button should look for the first empty cel in column "A" on sheet2
2. it should then put data in A1, B1, C1 etc. This data comes from cells A4,
A5, G5, G6 from sheet1

can anyone please help me with the code that does just this please?
thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200509/1