Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default PLEASE HELP! Autofill Row Number (Second time posting question)

Hi all, How should I write macro code if I need no. to popup in
offset cell of column B cell if I enter any value in it. Like I want
macro to put 1 in cell A1 if I put any value in cell B1 and 2 in cell
A2 if I put any value in cell B2 and (3,4,5...)carry on down to row
500. I know the formula to do it but i want to do it by macro.
Please can any friend can help and please also advise what changes
could be make in macro code which should cover if i leave any cell
blank in column B in between when putting the values in cell.
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
Eulers Number - Can't post reply to previous posting Joel Excel Worksheet Functions 0 September 29th 08 05:35 AM
Auto numbering with letters - re-posting question from above rayybay Excel Discussion (Misc queries) 3 April 25th 08 07:56 PM
posting a question in the forum Carrguy Excel Programming 1 July 28th 06 09:25 PM
Q. Autofill question: Can I autofill alpha characters like I can numbers? George[_22_] Excel Programming 5 August 7th 04 10:33 AM
Third Time Posting this Question: Hyperlink Problem Jake Marx[_3_] Excel Programming 1 May 13th 04 06:46 PM


All times are GMT +1. The time now is 09:28 AM.

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

About Us

"It's about Microsoft Excel"