| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
pasting formulas into a selection
Hello,
I need to insert into cells some data. i have <x amount of rows, and 5 columns Column1: blank Column2: blank Column3: is a formula =IF(A<row="","",A<row&"/ "&B<row) Column4: is a formula =IF($A<row = "","","Enter Email Address") Column5: is a formula =IF($A<row = "","","Enter Role") i can see selecting the rows ActiveSheet.Range(Cells(1, 1), Cells(1, 5)).Select then use selection, which is the Range object to do someting? can anyone help? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas in range and pasting in a selection | Excel Worksheet Functions | |||
| Pasting a Selection as a Picture | Links and Linking in Excel | |||
| Pasting Selection In First Blank Row | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| pasting formulas into a selection | Excel Worksheet Functions | |||
Threaded Mode
