Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
such next free rows
Hello
i need help to finalyse the vba code. the vba code is working but i need to find the first empty line and paste the data from the (excel base.xls). can someone help me Thanks Dim Wk As Workbook Set Wk = Workbooks.Open(Filename:="C:\Databasere_validierun g.xls") Windows("excel base.xls").Activate Range("B1:B75").Select Selection.Copy Windows("Databasere_validierung.xls").Activate Range("A4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True 'Wk.Close True' End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I free up the space occupied by empty rows? | Excel Discussion (Misc queries) | |||
EARN,20000$ & ALL TYPES SOFTWARE FREE DOWNLOAD,& KATRINA KAIF OPENVIDEOS & WEBSITE DEV TO FREE ALL OVER THE WORLD`S PEOPLE | Excel Worksheet Functions | |||
Free social world wide network pays for 10 generations! Free! | Excel Discussion (Misc queries) | |||
Where free 2 sigma statistical process control chart, free? | Charts and Charting in Excel | |||
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" | Excel Programming |