| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range without referring to specific cells
I've "discovered" the .Offset term in VBA and I see how it's used. I ca
select a cell to start at, then I can offset the selection by colum and row to get to a desired cell. So, now i'm wondering can I use thi offset function in combination with anything else to start in column and make a selection that ranges from column A to L? I can't specify range by cells becuase the data that I paste in always varys in length -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to specific cell in named range in Excel formula | Excel Worksheet Functions | |||
| Selecting data in a specific date range using COUNTIFS function | Excel Worksheet Functions | |||
| Selecting specific cells | Excel Discussion (Misc queries) | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
| Selecting specific row/column from a named range | Excel Worksheet Functions | |||
![abxy[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
