Just a question...
If you are copying the same formula down each time you import your data, why do you need to clear (delete?) the formula in the 1st place? I would think it would be far simpler to copy the formula down to way past where you think you would need them, and then just leave the formulas there, and modify them so that they show nothing if there is nothing in that row (ie, if the data does not reach down that far)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
JBeaucaire: Thank you, I will try this.
FDibbins: Ok, if the equation won't show up, that would be fine. I just don't want a lot of error messages. How would I do this?
Thank you both for the help!
~az!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks