| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude image
hi all
The following code copies and pastes a data range "appendix" to a sheet "contract". How do i amend so that the images within this range do not copy....only the data (text) does?? Cheers!!! Private Sub CommandButton1_Click( Dim tm tmp = Worksheets("quote2").Range("appendix").Rows.Coun Worksheets("contract").Activat Cells.Find(What:="appendix1.0", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart).Offset(2, 0).Selec Selection.Resize(tmp, 1).EntireRow.Inser Worksheets("quote2").Range("appendix").Cop ActiveSheet.Past Application.CutCopyMode = Fals End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically adding image extension ".jpg" to end of image name | Excel Discussion (Misc queries) | |||
| Transfering one image to another image | Excel Discussion (Misc queries) | |||
| Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions | |||
| Export the worksheet background image as an image file - possible? | Excel Programming | |||
| Open image from web in window same size as image? | Excel Programming | |||
Threaded Mode
