| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why won't this vba work, when this one does...
works:
Set sourceRange = mybook.Worksheets(1).Rows("1:150") Set destrange = basebook.Worksheets("import").Rows(Lr) That code copies row 1-150 and paste it into the first empty row, however I want it to copy all rows that is not empty... doesn't wrok: Set sourceRange = mybook.Worksheets(1).Columns("A:K") Set destrange = basebook.Worksheets("import").Rows(Lr) I want it to copy column A-K and paste it into the first empty row |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
