| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range select
Please translate the following commands into working code. Range A3 select find the last row go to F colum and select the aria A3 to Fi then delete and go to Range (a1) select Can anyone help me GG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range select
Dim cLastRow As Long
Dim rng As Range cLastRow = Cells(Rows.Count, "A").End(xlUp).Row Set rng = Range("A3:F" & cLastRow) rng.Delete Shift:=xlShiftUp Range("A1").Select -- HTH RP (remove nothere from the email address if mailing direct) "GG" wrote in message ... Please translate the following commands into working code. Range A3 select find the last row go to F colum and select the aria A3 to Fi then delete and go to Range (a1) select Can anyone help me GG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Select a range | Excel Programming | |||
| Select Sheet then Select Range | Excel Programming | |||
| Select Range as far as..... | Excel Programming | |||
Linear Mode
