| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
next avaliable range
I want to export some values from one sheet to another , but i want to put
them exactly in specified ranges . For that , i have predefine 8 ranges at sheet 2 range1, (from celll a1 to a14) range2,(from cell b1 to b14) range3 (from cell a15 to a30) range 4 (from cell b15 to b30) range 5 (from cell a31 to a45) etc. I want to find which range is empty in order to put in it the values from sheet1. (the macro which takes the values from sheet1 and paste it to sheet2 is ready except the above part ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| option not avaliable | Excel Discussion (Misc queries) | |||
| Insert Tab not avaliable | Excel Discussion (Misc queries) | |||
| How to expand coloms beond the last avaliable one in a Worksheet | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Threaded Mode
