Anyone now the code to select the last used cell in a column and drag it down one row using autofill to keep all the formulas?
Anyone now the code to select the last used cell in a column and drag it down one row using autofill to keep all the formulas?
Here is an example.
Type in a bunch of numbers in column A and run the code.
Please Login or Register to view this content.
Dave is it ok If i send you my file coz I think what I'm after is slightly more complicated?
Dave
Attached is the file, looking at the vol calcs tab, what I'm trying to do is select the final populated row between columns C and I and then drag/autofill down 1 row in line with the exchange rate. If you look at module 4 I have managed to write the code get the exchange rates, but now I want to populate the calculations next to it? Does that make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks