Hi All
I know how to fill down to the last non-empty row using a macro like the following:
What about when you need to do it the other way round for columns instead or rows, can some-one assist with a macro.
Please Login or Register to view this content.
Thanks in advance
Is it the same formula that you need to copy, changing the column from 3 to 4, then to 5, etc?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
No, the macro I used is just an example and I have applied it in different situations, I would like to do the same column-wise even if the formula is a simple =sum(D12:D20), also need to know how to change it when the formula is an array.
There are many ways to go about it.
One of them could be - you could loop through the columns. You could also use the FormulaR1C1 method of inputting the formula and use it along with the loop to put the formula in.
Is there a macro like:
Please Login or Register to view this content.
Dont understand what you mean by the above.One of them could be - you could loop through the columns. You could also use the FormulaR1C1 method of inputting the formula and use it along with the loop to put the formula in.
Try this
It will check for the last column based on what is populated in the 1st row.Please Login or Register to view this content.
Then it loops populating each column. Note the formula also, has the i there to allow it to loop through the columns.
You have used formula so you can directly put in in the vlookup formula like thisOriginally Posted by Floydlevedale
If you use FormulaR1C1 reference, the method of writing will be different. Instead of saying range A2, in formulaR1C1, you would be saying R[2]C if you are in the same column. Check it up online too and you will understand.Please Login or Register to view this content.
Tried the macro, but it didnt work, I probably havent explained myself properly, so please see attached workbook, macro should do each worksheet in turn. The formula to fill in is highlighted in yellow.
I need to do this daily and the workbook can have up to 20 worksheets, so a macro would save me loads of time
If you take sheet1, for which columns do you want the formula to be autofilled? Also will the formula always be in row 4?
The number of columns will vary from wrksheet to wrksheet but max 18 columns, yes formula will always be in row 4
So will the formula be in the first column and it needs to be auto-filled uptil the last column?
Yes, that's correct
Try this code
Please Login or Register to view this content.
Thanks, work perfect now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks