Copy a formula down in blank cells

Hi,

I'm pretty new to VBA and I need to create a macro. I have managed part by using the record macro function (though I'm sure this can be simplified). However, I am coming unstuck as I do not know how to copy the fomulae in column T down to the last cell in column T where the colum one to the left (S) contains data. The current macro just copies down to a pre specied cell. I alos then need to sum the column of data.

Below is how my macro currently looks. Any help you can give me with the Macro would be very much appreciated.

Please Login or Register  to view this content.

Thanks all for your help,

Kp

One major cleanup you can do is remove all the ActiveWindow.ScrollRow and smallscroll lines.

Why dont you attach the file that you are using?

Why are you using text to columns at the beginning of your code?

Kevin, try this.
BTW, you don't have to copy/paste from notepad, turn on the recorder and click open file (or import) and select the file, it will say its not a recognised filetype and then give you the text to columns dialog, set your arrays and then replace the code in red with the new code. Then you can run the code without opening the text doc.

Please Login or Register  to view this content.

No problem. If you consider the question answered remember to mark the thread as "solved".


To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Alternatively,

Marking threads "Solved" just got better. Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved. To undo the action, just go back to Thread Tools -> Mark this thread as Unsolved.

Thanks for that Arlu, forgot about the new method of marking posts solved.