hanging

Need help on creating a macro for this scenario, I hope this to automatically run as I change value. If I enter 5 on C2 the macro should put "X" on D2:H2 If I enter 3 on H3 the macro should put "X" on I3:K3 This i currently what I have but it is hanging for some reason. Private Sub...

Hello- I have a "Sheet Creator" that runs and creates a sheet, formats it, inserts formulas, and then allows user input of a few pieces of data to create a fairly in-depth report. Anyway, near the end of the coding the sheet is hanging up on a formula, see the red section of coding below. I have...

Why the Hanging Indent always sticks with the first tab in the Main Line? You know... When you press ctrl+T the above tab (mostly ":" character) moves with the hanging indent. Why the word has been built in this way? Example: Residence Address : No...

Hi all, Let's assume we want to get a pointer to a workbook opened in a second insatnce of excel and edit a cell .. we would normally use something like this : Sub Test() Dim wb As Workbook Set wb = GetObject("C:\MyBook.xls") wb.Worksheets(1).Range("a1").Value = 10 End Sub The...