| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selectign a range
hi,
does anyone know, how to select range. for example, i am trying to select values from first cell to the last cell in column B. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
selectign a range
Maxtm8,
Range(Range("B1"), Range("B65536").End(xlUp)).Select John Maxtm8 wrote: hi, does anyone know, how to select range. for example, i am trying to select values from first cell to the last cell in column B. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
selectign a range
i found this one, and it works. thanks
Dim x As Long x = Range("A" & Rows.Count).End(xlUp).Row Range("a1:a" & x).Select ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
selectign a range
The rude and crude way
Dim lrow As Long lrow = Cells(Rows.COUNT, "B").End(xlUp).Row Range(Cells(1,2),Cells(lrow,2)).Select But keep in mind that there are many things you can do with out selecting For example Range("A1").Select Range("A1").Copy Range("B1").Select Range("B1").Paste can be replaced with Range("A1").Copy _ Destination:= Range("B1") -- sb "Maxtm8" wrote in message ... hi, does anyone know, how to select range. for example, i am trying to select values from first cell to the last cell in column B. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| 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) | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming | |||
Linear Mode
