If posting code please use code tags.

[Tomred]

What are code tags?

I don't want to post wrongly...........

Thanks in advance.

 

[Joe4]

Take a look here:
http://www.mrexcel.com/forum/misc.php?do=bbcode

If you click on the Code word, it will show you an example.

This maintains spacing for readabilty.

 

[Tomred]

Thanks jm,
I didn't realise it was referring to forum post formatting.
I didn't know it was VB ....I suppose to be honest I never thought about it....the lanugage used in forums to post messages. How do you recognise one from the other?

I though the subject to this posting was referring to a particular method to use when posting code samples.

Cheers

 

[Joe4]

Tomred,

Not quite sure what you mean or what you are after. Perhaps a little example would help show you. Here is a little snippet of code using code tags (start by putting the word "code" in square brackets at the beginning and then the word "/code" in square brackets at the end).

    If Target.Column = 1 Then
        If Len(Cells(Target.Row, "I")) = 0 Then
            Range(Cells(Target.Row - 1, "I"), Cells(Target.Row - 1, "J")).Copy
            Cells(Target.Row, "I").Select
            ActiveSheet.Paste
            Application.CutCopyMode = False
        End If
    End If

Notice how all the spacing and indenting is maintained. Now watch what happens if I post the exact same code without code tags:

If Target.Column = 1 Then
If Len(Cells(Target.Row, "I")) = 0 Then
Range(Cells(Target.Row - 1, "I"), Cells(Target.Row - 1, "J")).Copy
Cells(Target.Row, "I").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End If
End If

See how much easier the first one is to read follow? Now imagine if you have many lines of code, instead of just the few that I have posted.

 

[Tomred]

Hi jm
Your example clearly answers my question - thanks.

I had made this posting, my first..............
http://www.mrexcel.com/forum/showthread.php?p=1486827#post1486827

...........and have been requested to use tags, but didn't know what was being referred too.

Yes ......it make lots of sense, to use the standard format for code.

PS if there is anything you would like to add to my questions at that posting, all advice is appreciated.

Thanks again.

 

[Joe4]

Just be sure to put a backslash before the word in your ending "code", i.e. "/code". The starting one does not have the backslash, only the ending one. I edited your code posting in the thread you referenced.

 

[Tomred]

Thanks jm14,
I spotted my error, corrected it and added a little more content to the posting to make it clearer....then ran out of time.

I'll put a little more thought into my posting prior to posting in future.

Over keen to get a solution to the on going problem!



Food interuppted!!