Hello,
I keep getting Application-defined or object-defined error in the third line of this code and cannot figure it out the reason for it.
First step, I remove the $ from MyRange (converts $A1:$A100 to A1:A100). Second step, I want to paste the formula with this defined range into an offset cell.
Attempt 1
Attempt 2HTML Code:
And none of them worked. Thanks for your help.HTML Code:
Is DynRangeA a string? If so try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
@xldept
Yes. It is a declared string. The problem happens in here,
HTML Code:
Did you try the Address modification?
Hi ! Try This !
As per Excel Model Object :
Please Login or Register to view this content.No need any Select in code !
So better than ActiveCell just use [A68] …
And better than ActiveCell.Offset(, 5) just use [F68] !
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 07-07-2018 at 05:22 AM.
Removed the answer
Last edited by SjonR; 07-07-2018 at 05:34 AM.
I tried using your line and it did not work. I created a file to show the error. I was previously at work when I posted this thread and the firewalls do not allow me to update any file.
Looks like it was a coding glitch - this runs:
Please Login or Register to view this content.
Your revamped code worked. Thank you so much for your help. This saved me HOURS of work!!!!
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks