Hi all, I'm getting the error 1004 whilst running this macro. It was working fine earlier, any advice would be much appreciated.
Please Login or Register to view this content.
The error occurs on the line: "Selection.AutoFill Destination:=Range(Cells(1, 10), Cells(jLastRow, 10))"
Thanks,
Matt
Last edited by Matt2014; 03-31-2014 at 06:55 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Never use Merged Cells in Excel
Apologies done now
Hi,
the selected cell (bad way, better without using any Select in code …)
must be the fisrt cell in the AutoFill range …
I think it is easier not to autofill:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Hi Izandol,
Thanks for your advice. I'm new to all this so is what you've given me is that to replace the "Selection.AutoFill Destination:=Range(Cells(1, 10), Cells(jLastRow, 10))"
Thanks,
Matt
This code will replace these lines:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks