+ Reply to Thread
Results 1 to 12 of 12

Issue - white space inside code tags

  1. #1
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Issue - white space inside code tags

    I've posted a reasonably lengthy bit of code to this thread this morning and it seems that a lot of the white space from my original code has been stripped out.

    Where I've left a blank line amongst un-indented lines that has been retained, but the blank lines within the indented blocks have been removed. Is there a way to stop this happening? My code needs all the help to look tidy and readable that it can get!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Issue - white space inside code tags

    Can you post your code here and highlight the issue areas Andrew? That way the tech team can clearly understand your issue.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Issue - white space inside code tags

    I'll try ... here's an indented section of my code....

    Please Login or Register  to view this content.
    And the attached document shows how the same section appears on my screen
    Attached Files Attached Files

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Issue - white space inside code tags

    I am not seeing any difference and am viewing this page thru FF 9.

    Checked it in Chrome 18 and yet no difference.

    I also checked it in IE8 and i still dont see any difference.

    What browser are you using?
    Last edited by arlu1201; 04-23-2012 at 05:53 AM.

  5. #5
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Issue - white space inside code tags

    I'm at work, so using IE9 - I'll check it tonight on Opera, but I'm not seeing any blank lines before the start of the For loop, the If block or the 2nd With block

  6. #6
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Issue - white space inside code tags

    The code looks as per your Word doc, here it is formatted and posted again
    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Issue - white space inside code tags

    OK, in your code I now see a blank line between the For and the If, but nowhere else - so it's looking like an IE issue.

    Just to prove I haven't been drinking (much) the attached is how my original code post looks on my screen...
    Attached Files Attached Files

  8. #8
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Issue - white space inside code tags

    Seems that it needs coding to cope with IE!

  9. #9
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Issue - white space inside code tags

    Yup. Decided to leave the office early and head home, and I can confirm that everything displays just fine in Opera.

    Maybe I should just install a proper browser on my work computer

  10. #10
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Issue - white space inside code tags

    IE does not seem to be compatible with most good stuff . We have had a few other issues that were brought up because of IE incompatibility.

  11. #11
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Issue - white space inside code tags

    damn those niche browsers

  12. #12
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Issue - white space inside code tags

    Quote Originally Posted by JosephP View Post
    damn those niche browsers
    Lol , i see the javascript hasn't been adapted for IE9, i remember i had trouble with that but it's all sorted now

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1