#1   Report Post  
Posted to microsoft.public.excel.misc
Haza
 
Posts: n/a
Default counter

Please somebody!
I wount a visible counter to one of the cells that counts how many papers i
print out.
The first paper 1, second 2 and so on.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default counter

This can be done by recording your print macro, and then a line to the
macro the increments the value of a particular cell by 1. This
provides the counter mechanism you're looking for.

The line to add to your macro is
Range("sheet1!a1").Value = Range("sheet1!a1").Value + 1

Where your counter is located on Sheet1 cell A1. You can change this
to match your sprdsht, of course.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Haza
 
Posts: n/a
Default counter

Yeah, just so I mean,
Thanks Dave!

"Dave O" skrev:

This can be done by recording your print macro, and then a line to the
macro the increments the value of a particular cell by 1. This
provides the counter mechanism you're looking for.

The line to add to your macro is
Range("sheet1!a1").Value = Range("sheet1!a1").Value + 1

Where your counter is located on Sheet1 cell A1. You can change this
to match your sprdsht, of course.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I determine the number of cell formats in this workbook tucsonmissiledude Excel Discussion (Misc queries) 2 October 28th 05 05:59 AM
Did I stump everyone? Counter that ignores hidden rows TechMGR Excel Discussion (Misc queries) 2 April 5th 05 08:45 PM
Creating a counter that does not include hidden rows TechMGR Excel Discussion (Misc queries) 1 April 4th 05 10:11 PM
Row counter in formula jjpcpanama Excel Worksheet Functions 5 March 23rd 05 06:20 AM
Increment a counter in Excel COSdl Excel Worksheet Functions 2 March 4th 05 09:47 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"