Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste to word
hello
i did following macros for copying cell from sheet and paste on word application, i have used checkbox also. it works properly. But i could not used more than one checkboxes. i mean if i checked two checkboxes or more , it should copy two sheets or more as specified and paste on word as separate pages for separate sheets. Private Sub CommandButton1_Click() Dim Objword As Object Set Objword = CreateObject("word.Application") Objword.Visible = True If CheckBox1 = True Then Sheets("summary unit rate").Range("A1:F45").Copy Objword.Documents.Add Objword.Selection.PasteSpecial Application.CutCopyMode = False Set Objword = Nothing Else: Objword.Visible = False End If End Sub help me to do this. pmss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word : Paste specialPaste Link Excel Chart Obj doesn't | Charts and Charting in Excel | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
paste to word | Excel Discussion (Misc queries) |