Please Login or Register to view this content.
whats wrong with this code??
Please Login or Register to view this content.
whats wrong with this code??
Last edited by RoOmIE; 10-08-2013 at 02:59 PM.
It looks OK to me, apart from the range you are filling from is the same as the same as the range you are filling to.
Is there any other code?
If posting code please use code tags, see here.
Please Login or Register to view this content.
i want to fill the columns underneath the vlookup
here is an exaple for 4 columns
but i want to code it for a generic amount of columns and a generic amonut of rowsPlease Login or Register to view this content.
Where are you putting the initial formulas, ie the ones you want to copy down?
Last edited by Norie; 10-08-2013 at 11:31 AM.
which formula? the vlookup?
i am putting the code in a module if that helps ..
No, where are you trying to put the formulas on the sheet?
The problem with the code is caused by the range you are copying from is the same as the range you are copying to.
Copy the ranges with the formulas inserted by the loop, not sure what that is but I think it's starts in Cells(6, 10) (or Range("F6")).
i want to auto fill J6 to exaple M6 all the way down with the auto fill function
yet i believe that i have found a mistake in the code ...
Please Login or Register to view this content.
they start at cells j6 and go to cells dependeing on how many loops or sheets go on to lets say M6 for 4 iterations ... then i want to fill the rest of the table going downwards
norie i am sorry but i don't really understand what you mean ..
That looks right, apart from the unneeded Selects.
Please Login or Register to view this content.
What don't you understand?
i replaced it with the code that you put on here and i still get the same 1004 error
and it has m6 as the active cell right before the error
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
As for what I'm tryng to say, here's an example.
If you have a formula/value in A1 and you want to autofill down to A10 you would use this,
you wouldn't use this.Please Login or Register to view this content.
Please Login or Register to view this content.
the sample file is too big its 2 Megs i can`t upload it unless i use another site and i don't have access to my dropbox right nowPlease Login or Register to view this content.
roomie 02-10-2013.xlsx
please use the above code with the sample file .. thanks again norie
got it .. thanks !!! it works..
What fixed it?
i had to reset the the last column and the lastrow value ...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks