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

Not sure I understand the problem, as you say it run fine normally and
stepping through the code.
Either way, some code of the problem area would help.

NickHK

"Ice" wrote in message
...
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