would like to copy infor into word - help!

Sure there is ptobably a better way, but this may help you.

Try using the print screen button

Then open up MS paint.

Edit > Paste

Crop the part you want to use.

Save that file.

Now you can attach the file in a few formats depending on your requirements.

Hope this helps

This will get a selected range in VBA over into Word, I have added a few lines so you can edit as needed, let me know if you require more assistance

Kindest possible regards

Jack in the UK

Code:

Attribute VB_Name = "Module1"
Sub Excel_to_Word_JackintheUK()

Range("A1:A20").Select
Selection.Copy

Set Word6 = CreateObject("Word.Basic")
With Word6
If UCase(Left(Application.OperatingSystem, 3)) <> "MAC" Then
.AppRestore
.AppMaximize 1
Else
AppActivate "Microsoft Word"
End If
.FileNewDefault
'.InsertPara
.Insert "Jack - Test from Excel"
.startofline 15
' .Bold
' .CenterPara
'.startofline 15
Selection.PasteSpecial Paste:=xlValues, operation:=xlNone, _
skipblanks:=False, Transpose:=False
Application.CutCopyMode = False

End With



End Sub

Lynda
I'm not sure whether the screens you're referring to are "excel screens". If so then Jack's answer will be right. If you don't want to use VBA then copying and pasting will do the job.

Note that if the range you're copying is a named range and you insert it as a paste link and subsequently insert rows or columns (within the named area) then (when refreshed) the item viewed in word will grow to accomodate the larger area.

If the screens you're pasting are not excel but purely images you'll need to use a graphics editor to "crop" the image to size before you paste it in. Note that even simple graphics editors such as Microsoft Photo Editor will allow you to do this.

Hope this helps.