Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste (visual basic)
i need to copy and paste addresses from on sheet to another depending on the
cell value EXAMPLE: IF cell a2 on sheet 1 says "1" then copy the address (cells a1 to a5 on sheet 1) to cells d1 to d5 on sheet 2 if cell A2 on sheet 1 says "54" then copy THAT address (cells a1 to a5 on sheet 1) to cells d10 to d15 on sheet 2 ANYONES HELP WOULD BE VERY APPRECIATED thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste (visual basic)
This would have been the best place to post. Pls STOP multiposting
-- Don Guillett SalesAid Software "ian123" wrote in message ... i need to copy and paste addresses from on sheet to another depending on the cell value EXAMPLE: IF cell a2 on sheet 1 says "1" then copy the address (cells a1 to a5 on sheet 1) to cells d1 to d5 on sheet 2 if cell A2 on sheet 1 says "54" then copy THAT address (cells a1 to a5 on sheet 1) to cells d10 to d15 on sheet 2 ANYONES HELP WOULD BE VERY APPRECIATED thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste (visual basic) | New Users to Excel | |||
help to paste via visual basic | New Users to Excel | |||
visual basic (copy and paste) | Excel Worksheet Functions | |||
visual basic command to special paste a row of formulas into value | Excel Programming | |||
Having troubles using visual basic to paste info from one workbook to another | Excel Programming |