LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Autofill Forumal Down Column

I am currently working on setting up a call cost register for my workplace.

I have set up formulae in columns D, E and I, beginning at row 4 (so, D4, E4
and I4) to calculate various figures; however, I need a macro that will
either:

1. Autofill those formulae down the column regardless of whether the
previous row was fully completed (column I is the final column of the
register and does not always require an entry); or,

2. Allow those 3 formulae to function within every following cell of those
columns (for instance, the formula is D4 will function in ever cell from D4
to D65536)

I have very limited VBA knowledge, so if anyone could help it would be
greatly appreciated.
 
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
If Then forumal DJ Excel Worksheet Functions 7 July 3rd 08 02:33 AM
Worksheet forumal help James@ Setting up and Configuration of Excel 1 December 1st 06 01:25 AM
filling forumal by colums Dark Helmet Excel Discussion (Misc queries) 1 August 23rd 06 08:23 AM
Seeking Help with a forumal. [email protected] Excel Programming 2 April 7th 06 10:39 PM
forumal does not work Excel Worksheet Functions 0 November 11th 05 02:10 AM


All times are GMT +1. The time now is 03:54 AM.

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"