VBA for tables

[mib1019]

I know this is simple. I appreciate your time to help me!

I have a table listobject called "TimeData".

Need VBA to insert row above the current row. And VBA to delete the current row.

Going to put both on buttons above the table. Need the VBA to test that the row is within the range between the header and the total row.

Thanks!
MB

 

[bobsan42]

DUH. I knew that. But my mind is a mystery! Thanks!

The mind in genetal is still a mystery IMHO. Sometimes it works, sometimes it doesn't. Don't beat yourself up about it ?

 

[mib1019]

Bobsan42, I posted another question on a separate thread, but haven't received any answers. Maybe you can help me with it.

Sure would appreciate help with this.

ProjectInfo listobject resides on Project Info worksheet. TimeData listobject resides on Time Input worksheet.
"Project Name" is the first column in ProjectInfo. "Project" is column 4 of TimeData. Data validation on that column is set to ProjectList (named range for column 1 on ProjectInfo).

There are times when the Project Name changes in that column supplying the list for data validation. Once that happens, the corresponding rows in the Time Input table are 'orphaned'.

I need code that captures the 'oldname' and 'newname' when changed, and then loops through TimeData and changes the cells in Project column where 'oldname' is found.

Thanks in advance.
MB