Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a script for printing form (sheet "PZ") with data from one sheet
(sheet "list") from active cell in sheet "list". And I want to use in this form also data from another sheet ("projekty") from the same row number as in sheet "list". But I don't know how... Can you help me someone. I'm sending the script I tried to use, but it didn't work. Sub PrintPZ() Dim i As Long Sheets("list").Select For i = ActiveCell.Row To ActiveCell.Row Sheets("PZ").Range("C13").Value = Range("C" & i).Value Sheets("PZ").Range("E32").Value = Sheets("projekty").Range("I" & i).Value Sheets("PZ").Range("D34").Value = Sheets("projekty").Range("G" & i).Value Sheets("PZ").PrintOut End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print data only from form | Excel Discussion (Misc queries) | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
how do i print a form from excel data | Excel Discussion (Misc queries) | |||
how can i print a form/s that are in excel 2000 dataforms? | Excel Discussion (Misc queries) | |||
Print all data from list on seperate form | Excel Programming |