Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how can i get VBA to give rows numbers

I have made a formular to fill in data in a sheet, but i can't figur out how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default how can i get VBA to give rows numbers

Just use the ROW() function.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bahnando" wrote in message
...
I have made a formular to fill in data in a sheet, but i can't figur out

how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default how can i get VBA to give rows numbers


ActiveCell.Row


"Bahnando" wrote in message
...
I have made a formular to fill in data in a sheet, but i can't figur out
how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks



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
Which numbers give desired result Studebaker Excel Discussion (Misc queries) 14 April 29th 08 09:22 PM
how do i give numbers to documents in Excel? excel nombers Excel Discussion (Misc queries) 1 October 6th 07 07:02 PM
How to give numbers to the font colors Igneshwara reddy[_2_] Excel Worksheet Functions 2 August 24th 07 01:34 AM
How can i give formula to count the only numbers except zero in a Anuja Excel Discussion (Misc queries) 7 November 15th 06 06:52 AM
why does dividing numbers give me dates and not numbers? dylan Excel Discussion (Misc queries) 1 June 21st 06 11:40 PM


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

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

About Us

"It's about Microsoft Excel"