Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Macro Error "Too Many Line continuations" in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-12-2011
Member
 
Join Date: Dec 2011
Posts: 3
Macro Error "Too Many Line continuations" in Excel
  

I am trying to create a macro to filter about 160 brand names of 300, I started recording a macro and then using filter, i checked all the brand names i wanted, the problem is that when i finished i got the error msg " Too Many Line Continuations" what can i do to create a macro to filter only those 160 or so brands?

Reply With Quote
  #2  
Old 31-12-2011
Member
 
Join Date: Nov 2010
Posts: 502
Re: Macro Error "Too Many Line continuations" in Excel

Don't use so many line continuations maybe? In case you are not aware of what that message means... it occurs when you take a long line of text an split it up on multiple lines using a space followed by an underline to keep the links linked together. For example : SomeTextVariable = "Line one which goes on for awhile and " & _"then continues on, but one line lower" If I recall correctly, there are a maximum of 25 line continuations that can be used on a single code statement... so just don't break it apart so often... or see if you can split the multiline statement you are trying to construct into more than one statement, each of which can have a maximum of 25 line continuations.
Reply With Quote
  #3  
Old 31-12-2011
Member
 
Join Date: Nov 2010
Posts: 420
Re: Macro Error "Too Many Line continuations" in Excel

It would be better to have at least one extract files. This is a good way to have tranfer the contents of each file in a sheet of same workbook. Anyway at the conceptual level object instances are the same but the way is different, but the result is the same. You can not do without the variables that tell you the last line of each sheet.
  • In any case it is a necessary routine in almost all cases.
  • Try to use variable names suggestive: Since I do not file your I transformed variables in a way more meaningful to me and I added two variables that store the last line of each sheet (ILR and JLR) and a variable k COUNTED rows added.

Too many line continuations
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Macro Error "Too Many Line continuations" in Excel"
Thread Thread Starter Forum Replies Last Post
Starting Spec Ops: The Line gives error "sync out of range" on monitor Nasir h Video Games 6 06-07-2012 12:14 PM
Excel Macro Popup Message " Do you want to replace the contents of the destination cells" Darmody Windows Software 5 31-12-2011 04:16 PM
Windows Showing Webpage error: "Out of memory on line:17" Aaryan2011 Operating Systems 1 23-08-2011 11:17 PM
Error message "Cannot load dll " while loading vba macro Digamber Windows Software 3 09-05-2009 01:09 PM
Project Web Access via IE7: "Export Grid to Excel" cause VBSCRIPT (error) message: "The activeX control on which this feature depends could not be created" Theo-Dore Microsoft Project 2 17-01-2007 08:47 PM


All times are GMT +5.5. The time now is 06:45 AM.