Hi
I am new to vb. and would appreciate some help.
I am trying to copy a formula down the active column to the last row. But i cannot get it to work. I get the column set as cl as column 3 which is correct and the endrow as 119 which is correct but it does not move forward and I get a method range on object as global failed. Can anyone help?
Please Login or Register to view this content.
You never change the active cell so the formula is going to go in the same cell over and over.
It isn't really clear where you want the formula to go or how many rows to copy it down but give this a try.
Please Login or Register to view this content.
Last edited by Norie; 11-27-2013 at 09:27 AM.
If posting code please use code tags, see here.
You are attempting to put a Range, isStr, into a formula. Perhaps you want isStr.Address instead??
Gary's Student
Thank you, that makes sense. I need it to offset the formula down the column until the endrow then go back to the first cell in next column and loop again. Thank you i will have a play.
Thank you that worked on the isStr i will sort the code and post once fixed. 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