Thread: Barcode and VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ice Ice is offline
external usenet poster
 
Posts: 2
Default Barcode and VBA

hi,

I use windows xp prof and office xp prof. i n excel i have add-in that
generates for me bar code on the worksheet.
i took add-in from www.abarcode.net and it is demo version. i have macro
that does few steps for me. this steps a

1)copy value from cell A5 into N5
2)print a page with new barcode value
3)copy next value from A6 into N5
4)print a page with new barcode value
.....

a there can be many values in A column and macro run to the last one that is
not empty.

and here is my problem:

every printed page has always barcode with latest value from list, whenever
macro goes normaly. i wanted to check exactly how does it goes and i used
"step into" option of running macro. during this controled run everything
was fine and each page has printed correctly with proper barcode.

do you know how can i make this macro to print correctly on every single
page?or what is the reason of such behavior?

thanks in advance