VBA Writing style. Advise

[pedie]

1. I was writing macro manually and I dotn know what I did but the cursor blink became bold and I dont know how to return that to normal cursor mode
2. Is manual way of writing macro called relative macro or othewise what is it called....?
3. I have seen someone write a macro in style like below code....it move the line in and then come out again...
do we manually do that as does it automatically happen...
because when i write the code it does not happen...

Sub try2()
With Sheet1
  lr = .Cells(Rows.Count, "A").End(xlUp).Row
    For i = 2 To lr
      If .Cells(i, "D").Value >= .Cells(2, "H").Value Then
         .Range("A" & i & ":G" & lr).Copy Sheets("Home").Range("A1")
       Exit For
     End If
   Next i
 End With
End Sub

Thanks again!

 

[mikerickson]

Is the Insert button on your keyboard toggled?

 

[pedie]

I dont know what is toggled....
How are we suppose to toggle...like manually you mean?

 

[pedie]

The cursor blink is really huge now...10x more to normal cursor blink...it is soo distracting....i dont know why...how can i make it smaller...?

 

[pedie]

i dont know how but after i close & reopen it is okay now...i mean the bold bog cursor...

 

[meldoc]

Hi Pedie

1. ?
2.No. See the links.

http://www.mrexcel.com/tip077.shtml

http://www.youtube.com/user/bjele123#p/search/14/Wbno0bcUnQI
I know above says 2010, but it's just the same.

3. See the links.

http://books.google.co.uk/books?id=...6AEwCDgK#v=onepage&q=indent excel vba&f=false

http://www.vbaexpress.com/training/lesson01.htm

 

[pedie]

Meldoc, i thought everone has given up this thread...thank you soo much for writing back.
That was what I was looking for.
Thanks again!

Pedie

 

[Nalani]

There's an Addin-in out there called Smart Indenter to automatically Indent for you located here

http://www.oaltd.co.uk/Indenter/Default.htm

 

[Norie]

1 All that's happened is that the Insert button has been pressed. This has nothing to do with VBA it could happen in any application.

2 Don't know what you mean, I've never seen 'relative' used to describe a way of coding - it's more to do with formula I guess.

3 It won't happen automatically in the VBE, all the person is doing is pressing the TAB key to indent the code.

This is a good thing to do as it makes it easier to read and follow the code, and therefore makes it easier for you and other people spot errors.

You might want to look into using Option Explicit as well.

I've got an add-in for indenting but it doesn't do it automatically, unless I'm missing an option/setting.

 

[pedie]

So suppose if I want to move the code to center I have to like tab 8 times??? and there is no shortcut or anything?

Just curious....