tcell

I'm using this VBA, and it worked perfectly the first day, but over the weekend I came back to work, and it only works in the cells towards the bottom of the sheet, but not those on the top. I have no idea why it's doing that. Basically, column O is a notes column. Once I make a change in said...

The problem, I think, is that I'm ending up with illegal characters so can't use the string as a range name and I don't know where the characters are being inserted. I also understand a UDF can be created to clean the string, but I simply can't figure out to use the UDF with VBA. Help. TIA...

Daily I copy two worksheets into a new workbook. The worksheets names change daily so I'm trying to reference the sheets by index number and get the value from Cells(1 , 1). But I'm not getting the ranges set properly for the reference/copy from cells and can't figure it out. My initial attempt...

Hi, I have the following formula which date stamps into column D when something is entered into column E is there a way to delete the entry if the cell in E has been deleted Many thanks Private Sub Worksheet_Change(ByVal Target As Range) Dim rInt As Range Dim rCell As Range Dim...

Good Afternoon, I have created a worksheet which will insert the date and time in column B when each row is entered. I would like to now add (stamp) the windows username to the same cell if possible. This is the current code I run and would sincerely appreciate any help. :confused: Private...