CastingDirector
New Member
- Joined
- Jun 10, 2014
- Messages
- 46
Thanks to this forum, I am getting closer and yet...
My VBA now copies an entire row with contents from sheet 1 to sheet 2 when a dropdown is clicked in sheet 1 (called "Green Master"). My "non avail" (sheet 2) has a double click calendar with which I want to insert a date into cells in column "B".
Problem: The cell in "B" whose entirerow was copied now contains the Time format (from sheet 1) which prevents me from inserting the date via my calender module. Conditional formats of column B on sheet 2 does not work as the next time a new row is added that formatting copied over. Question: How can I remove the Time formatting in column "B" when it is moved from sheet 1 so I can input the calendar date?
I have no hair left. It (the hair) is on my desk yet the code remains.
Thoughts? Help?
Sheet 1 code snippet below:
ElseIf Intersect(Target, Range("A:A")) = "Calendar Conflict" Then
Target.EntireRow.Copy Sheets("Non Avail").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
My VBA now copies an entire row with contents from sheet 1 to sheet 2 when a dropdown is clicked in sheet 1 (called "Green Master"). My "non avail" (sheet 2) has a double click calendar with which I want to insert a date into cells in column "B".
Problem: The cell in "B" whose entirerow was copied now contains the Time format (from sheet 1) which prevents me from inserting the date via my calender module. Conditional formats of column B on sheet 2 does not work as the next time a new row is added that formatting copied over. Question: How can I remove the Time formatting in column "B" when it is moved from sheet 1 so I can input the calendar date?
I have no hair left. It (the hair) is on my desk yet the code remains.
Thoughts? Help?
Sheet 1 code snippet below:
ElseIf Intersect(Target, Range("A:A")) = "Calendar Conflict" Then
Target.EntireRow.Copy Sheets("Non Avail").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)