Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modfiy row of VB to select range of columns
Hi there,
I currently have VB (extract below) that says Set sh = bk.Worksheets("James") Set dest = ThisWorkbook.Worksheets(1).Cells(i, 1) i = i + 1 sh.Rows(3).Copy I want to change the last line of text to enable me to select all rows with text in at least column A, or if thats too dificult then to select from row 1 to row 300, what is the syntax for the last line of code... Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select different columns within a range | Charts and Charting in Excel | |||
Select updated data from a range of columns | Excel Worksheet Functions | |||
VBA Range Issue : Cannot programatically select more than 42 columns | Excel Programming | |||
Select Sheet then Select Range | Excel Programming | |||
Select a range of columns based on active cell | Excel Programming |