PC Review


Reply
Thread Tools Rate Thread

how can i get VBA to give rows numbers

 
 
=?Utf-8?B?QmFobmFuZG8=?=
Guest
Posts: n/a
 
      24th Oct 2006
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 With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      24th Oct 2006
Just use the ROW() function.

--
HTH

Bob Phillips

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

"Bahnando" <(E-Mail Removed)> wrote in message
news:C5930154-6D83-400C-9046-(E-Mail Removed)...
> 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 With Quote
 
Goofy
Guest
Posts: n/a
 
      24th Oct 2006

ActiveCell.Row


"Bahnando" <(E-Mail Removed)> wrote in message
news:C5930154-6D83-400C-9046-(E-Mail Removed)...
>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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i give numbers to documents in Excel? =?Utf-8?B?ZXhjZWwgbm9tYmVycw==?= Microsoft Excel Misc 1 6th Oct 2007 07:02 PM
How to give numbers to the font colors =?Utf-8?B?SWduZXNod2FyYSByZWRkeQ==?= Microsoft Excel Worksheet Functions 2 24th Aug 2007 01:34 AM
why does dividing numbers give me dates and not numbers? =?Utf-8?B?ZHlsYW4=?= Microsoft Excel Misc 1 21st Jun 2006 11:40 PM
how to find numbers that give another number Rossella Microsoft Excel Discussion 1 19th Apr 2006 05:56 PM
Does XP give you more IRQ numbers than 98?.... plh Windows XP Basics 3 16th Jul 2004 08:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:12 PM.