Forum Discussion
Copy and paste checkable text
Oh Sorry!
That's because the code depends on the row number of the last filled cell in the Notes column to identify the last row of the selected names.
Now, I've updated it to compare the Notes column and the Names column and choose the column in which the last row number is greater than the other.
Consequently, even if you have a note without a name, it will be copied!
Hope that helps
But where is the copy button ?
Oops sorry for that!
I have inserted it again into the worksheet.
- Thank you very much for your help
But where is Dave?
I told that SOMETIMES i need to write something in Notes coloum.
Please find attach.
I selected Dave but it will not copy!
Why?
Please help me to solve it.
ALWAYS i will write something in Names column.
But SOMETIMES I write something in Notes coloum.
I need to copy Dave even there is nothing in Notes coloum.
Thank you very much for your helpOh Sorry!
That's because the code depends on the row number of the last filled cell in the Notes column to identify the last row of the selected names.
Now, I've updated it to compare the Notes column and the Names column and choose the column in which the last row number is greater than the other.
Consequently, even if you have a note without a name, it will be copied!
Hope that helps
- Great!
That's what I want.
Thank you very very much for your help.
