here's my problem

I'm trying to generate raffle tickets with Excel

I have an image that is 3 inches by 7 inches.. that's the raffl
ticket.

on it I would like to add some text.. in particular two cells woul
contain teh ticket number.

I'll run a macro that will generate a ticket number and increment i
and print a page and keep looping for as many tickets as I need.

the problem I'm having is using a cell that is over the image..

any tricks???

help!!?

--
Message posted from http://www.ExcelForum.com

Pabs,

Here's one idea. Place a text box (from the drawing toolbar) on top of your
image, format it so that it blends in nicely, then use something like this

Sub Macro1()
For ncounter = 1 To 100
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = CStr(ncounter) 'or whatever value you want
'PRINT HERE
Next ncounter
End Sub

Robin Hammond
www.enhanceddatasystems.com

"pabs " wrote in message
...
here's my problem

I'm trying to generate raffle tickets with Excel

I have an image that is 3 inches by 7 inches.. that's the raffle
ticket.

on it I would like to add some text.. in particular two cells would
contain teh ticket number.

I'll run a macro that will generate a ticket number and increment it
and print a page and keep looping for as many tickets as I need.

the problem I'm having is using a cell that is over the image..

any tricks???

help!!??


---
Message posted from http://www.ExcelForum.com/

pabs,
Depending the style of your image, applying it as the background (Format --
Sheet -- Background) then playing with column withs and row heights to get
the desired effect.

NickHK

"pabs " wrote in message
...
here's my problem

I'm trying to generate raffle tickets with Excel

I have an image that is 3 inches by 7 inches.. that's the raffle
ticket.

on it I would like to add some text.. in particular two cells would
contain teh ticket number.

I'll run a macro that will generate a ticket number and increment it
and print a page and keep looping for as many tickets as I need.

the problem I'm having is using a cell that is over the image..

any tricks???

help!!??


---
Message posted from http://www.ExcelForum.com/

"NickHK" wrote in message ...
pabs,
Depending the style of your image, applying it as the background (Format --
Sheet -- Background) then playing with column withs and row heights to get
the desired effect.

NickHK

"pabs " wrote in message
...
here's my problem

I'm trying to generate raffle tickets with Excel

I have an image that is 3 inches by 7 inches.. that's the raffle
ticket.

on it I would like to add some text.. in particular two cells would
contain teh ticket number.

I'll run a macro that will generate a ticket number and increment it
and print a page and keep looping for as many tickets as I need.

the problem I'm having is using a cell that is over the image..

any tricks???

help!!??


---
Message posted from http://www.ExcelForum.com/



Try this site www.XL-Logic.com and search for "WATERMARK"

Try this site www.XL-Logic.com and search for "WATERMARK"