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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modfiy row of VB to select range of columns
to do all rows in the range Sheets("James").Select Range("A1:A300").Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet1").Select Range("A1").Select ActiveSheet.Paste |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modfiy row of VB to select range of columns
Thanks - thats the normal way to select rows, but within this code it doesnt work as it just enters into a strange loop. I think its not specific - ie telling excel to advance a certain number of columns, like I + 299.... Tom you out there.....? *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
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 |