LinkBack URL
About LinkBacks
Hi,
I am trying to break code line in several short ones. I am using underscore as break point.
It seems I am doing something wrong.
Please help.
Thank you
Jaz
Hi,
I am trying to break code line in several short ones. I am using underscore as break point.
It seems I am doing something wrong.
Please help.
Thank you
Jaz
Last edited by jazbath; 05-22-2010 at 09:19 PM.
It's actually a space followed by an underscore.
Entia non sunt multiplicanda sine necessitate
Hi Shg,Originally Posted by shg
Thanks for replying. Yes I am doing the same, but I get this error "expected list separator or (" Here is the code line:
ThanksHTML Code:
Jaz
Where the continuation forms a string you would use & _, the breaking line must end with " and the subsequent line must commence with " (ie joining two strings), eg:
However, in your example you can shorten the code to reflect the contiguous ranges, eg:
Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi DonkeyOte,Where the continuation forms a string you would use & _, the breaking line must end with " and the subsequent line must commence with " (ie joining two strings), eg:
However, in your example you can shorten the code to reflect the contiguous ranges, eg:Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you for helping. I tried what you explained, but it did not work.
here is what I am doing:
Let me know please. the error I am getting is "Application defined error"HTML Code:
Thank you
Jaz
Select the cells of interest and create a named range, which would be more flexible.
Please Login or Register to view this content.
Last edited by shg; 05-20-2010 at 05:25 PM.
Jaz, that's not quite what I suggested....
However, based on your latest code - you are perhaps missing a comma delimiter between the last range on the first line and the first range on the continuation line...
donkyOte,
I have tried that too it does not work.
Jaz
Post a sample illustrating the prior suggestions (not working).
DonkyOte & Shg,
Since Shg advised me to do ranges, I have tried that and managed to cut down the line length.
But still it is too long, I have 4 hrs. readings to grab from the log sheet. I am posting my present working code line. Please show me the syntax to break it into two, that will help me a lot.
Thank you
Jaz
Set Rng = WksSrc.Range("infoone,infotwo,infothree,oneMin,twoMin,fourMin,sixMin,eightMin,tenMin,twlMin,frteenMin,sixtnMin,eghtinMin,twntyMin,twnty5Min,thrtMin,frt5Min")
Jaz, we're going around in circles I think.
As already outlined:
That said you may still find the string is too long in terms of line continuations in which case create multiple shorter range strings and Union them into one large range upon completion, eg:Please Login or Register to view this content.
Please Login or Register to view this content.
There is no comma between g16 & b17Please Login or Register to view this content.
This line:
is not what SHG suggested. You were supposed to go to the first cell, C3, then while holding Ctrl, select each and every cell in the original range. Then give the entire selection a SINGLE name. What are you trying to do, maybe there's an alternative.Please Login or Register to view this content.
Ben Van Johnson
Exactly. And done in that fashion, it accommodates inserting & deleting rows & columns, as long as they're not part of the range.
Hi protonLeah,
Thanks for responding. I have to grab data from several cells in a run sheet. I am not interested in every bit of data in that sheet. You can see that from my ranges which are not in sequence. For this reason I named a bunch of cells which are in sequence for my convenience.
Anyway i guess it is working for now. but I will certainly try the way you explained what Shg has said,perhaps I did not understand correctly.
Thank you
Jaz
Hi ProtolLeah & Shg,
I tried that as one single range by selecting all cells holding ctrl key and it worked! Wonderful I had just put one single range instead of long line.
Thank you.
Jaz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks