tomcoll67
04-07-2009, 11:52 AM
Hi,
I am new to VBA and am looking for a way to get the cell data from a merged cell (AP AQ AR) in worksheet3 that is in a dataform and use it to send data from cell that is merged from Row 10 columns B through AF to Row 14 same columns. and move to Sheet 1.
The trick is that I need to use the number from the first merged cell(AP-AR) and add a value of three to it to denote the row to write to. The column will always be O.
There are other items I need to do but if I can get an understanding of these I think I would be able to do the rest.
I thank anyone who could help.
Tom :banghead:
I am new to VBA and am looking for a way to get the cell data from a merged cell (AP AQ AR) in worksheet3 that is in a dataform and use it to send data from cell that is merged from Row 10 columns B through AF to Row 14 same columns. and move to Sheet 1.
The trick is that I need to use the number from the first merged cell(AP-AR) and add a value of three to it to denote the row to write to. The column will always be O.
There are other items I need to do but if I can get an understanding of these I think I would be able to do the rest.
I thank anyone who could help.
Tom :banghead: