I am struggling for some hours already..
In the immediate window this works:
But this doesn't (error 1004):Please Login or Register to view this content.
Please Login or Register to view this content.
What am I not seeing here?
Thx...
I am struggling for some hours already..
In the immediate window this works:
But this doesn't (error 1004):Please Login or Register to view this content.
Please Login or Register to view this content.
What am I not seeing here?
Thx...
Last edited by ArnolddG; 03-07-2019 at 06:56 PM.
Not sure what to tell you, both work for me on one of my workbooks. Are you placing a ? at the start of the line in the immediate window?
Yes I did (I edited the post)
It seems to work fine after I have quit and opened Excel (2010).
The actual code should be this:
After I run this (in a module or the immediate window) the error 1004 pops up until I reset Excel again(!)Please Login or Register to view this content.
Could there be a maximum to concatenate ranges that Excel 2010 cannot deal with?
Last edited by ArnolddG; 03-07-2019 at 08:26 PM.
This works for me in a macro enabled workbook. Unfortunately, I cannot test in Excel 2010:
Not sure what the issue might be. There's a limit of 255 characters, if I remember correctly, but you haven't hit that.Please Login or Register to view this content.
Last edited by Melvosh; 03-08-2019 at 09:06 AM.
I found out that when I use this in a normal module everything is OK, but when I use the code in the ThisWorkbook Object (Private Sub Workbook_BeforePrint(Cancel As Boolean)), then I cannot use the range.
So my solution was to make a separate sub in a module and call that sub.
Problem solved!
Thanks for your input...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks