I am writing and running a macro (details below) i just need to rewrite it, so the range is the active cell but one row up (-1,0??) instead of A8:CK9.
Has anyone got any ideas to re-write in? i could also do with it being the entire row instead of just up to CK9
Marco is
etc
Please Login or Register to view this content.
Thank you for your help
Last edited by gavp; 03-04-2013 at 09:41 AM.
Try:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Its coming up a run time error?
Hers is the de bug code
Bit hightlight in red is where its sayin the error is?Please Login or Register to view this content.
Last edited by arlu1201; 03-04-2013 at 09:36 AM.
Gavp,
Welcome to the forum.
I have added code tags to your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
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]
Anyone have any ideas?
In looking at your code, it appears that you are trying to fill only one cell. In simple language, tell us what you are trying to do. If in fact you are only trying to paste a value into only one cell, then you do not need to use autofill. I am confused.
I am trying to create a marco to insert a new line (which i have done) but then copy all the forumlaes/validations from the line above, the above is done on both sheets, 'schedule' and 'costing'
Ivew got the insert bit fine, its just these cell always end up blank?
Replace this:
with thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks