| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rows & Cols - copy formulas in Col A to # rows in Col B
I need to insert formulas in Col A along side unknown # rows of data in Col B
but can't seem to get the coding correct. ie: Col B has continuous data in B3:B45 ; how do I enter a formula in A3 and using Range(Selection, Selection.End(xlToRight)).Select and/or Range(Selection, Selection.End(xlDown)).Select get the highlighted range to show A3:A45? Using Range(Selection, Selection.Offset(0,-1)).Select give me 3 Cols highlighted. Suggestions? Also what about when Col B doesn't have contiuous data in the rows? How do I determine and highlight the appropriate number of rows in Col A? Thanks -- Mikey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Subset of Rows/Cols | Excel Discussion (Misc queries) | |||
| #REF appearing when cells,rows,cols are all protected | Excel Discussion (Misc queries) | |||
| importing rows to cols | Excel Worksheet Functions | |||
| newbie question. abt cols and rows. | Excel Programming | |||
| Hide Unused Cols & Rows in a Range | Excel Programming | |||
Threaded Mode
