| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rows(arguments)???
Hey all
another question how do I use the Lastrow variable in the Rows argument??? Dim Lastrow As Long With ActiveSheet Lastrow = .UsedRange.Rows.Count + .UsedRange.Cells(1).Row - 1 Rows("1:Lastrow").Select Selection.Copy Thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many rows (arguments?) can be seached by Vlookup function? | Excel Discussion (Misc queries) | |||
| IF-more than 7 arguments in | Excel Worksheet Functions | |||
| And, if, arguments.... | Excel Worksheet Functions | |||
| Counting rows with two arguments | Excel Discussion (Misc queries) | |||
| arguments | Excel Discussion (Misc queries) | |||
![dabith[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
