About Us

open a adobe file from a command button

That Works great!
Thank You very Much!!

"Nigel" wrote:

Replace this section ......

Debug.Print " Row is " & Row & _
" Unit is " & Unit & _
" Shelf is " & Shelf & _
" Position is " & Position

with this.........

With Sheets("Sheet1")
.Cells(xx, 1) = "Row is " & Row
.Cells(xx, 2) = "Unit is " & Unit
.Cells(xx, 3) = "Shelf is " & Shelf
.Cells(xx, 4) = "Position is " & Position
End With

--

Regards,
Nigel

"open a adobe file from a command button"
osoft.com wrote in
message ...
The person that wrote this code is no longer around. It works great in
the
immediate window. My question is what do I do to get it to print onto a
worksheet?

Thank You

Sub bill()
'Dim varibles
Dim xx As Integer
Dim Row As Integer
Dim Unit As Integer
Dim Shelf As Integer
Dim Position As Integer
Dim Rowcounter As Integer
Dim Unitcounter As Integer
Dim Shelfcounter As Integer
Dim Positioncounter As Integer

'Set varibles starting number
Row = 1
Unit = 1
Shelf = 1
Position = 0
Rowcounter = 1
Unitcounter = 1
Shelfcounter = 1
Positioncounter = 1
xx = 0

Do While xx <= 50
xx = xx + 1
Position = Position + 1

If Position = 6 Then
Shelf = Shelf + 1
Position = 1
End If

Debug.Print " Row is " & Row & _
" Unit is " & Unit & _
" Shelf is " & Shelf & _
" Position is " & Position

Loop
End Sub

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chart doesn't print w/worksheet properly but will print by itself	Vera	Excel Discussion (Misc queries)	2	November 7th 08 05:49 PM
how do u print back2back print of different worksheet in exel.	Nitin D	Excel Worksheet Functions	0	May 23rd 08 01:57 PM
Print worksheet but dont want two cells too print is it possible	pano[_3_]	Excel Programming	9	October 21st 07 02:25 PM
print a specific area within a worksheet by clicking on print?	honclub	Excel Worksheet Functions	1	October 29th 04 03:22 AM
Print Macro that will Print Entire worksheet except....	Ron de Bruin	Excel Programming	0	July 1st 04 04:26 PM

Menu

About Us