@MaybeHi,
Please try the method in this article:
How to remember or save previous cell value of a changed cell in Excel?
https://www.extendoffice.com/documents/excel/5056-excel-remember-save-previous-cell-value.html

@Michael FergusonHi Michael,
You just need to create a button (such as a Button (Form Control)) in your worksheet, then assign the macro to the button.

@Reinaldo BatistaGood day,
Just below ".Body = xMailBody" add the following
.Attachments.Add ActiveWorkbook.FullName

@jamesHi James,
Do you want to send the active worksheet as pdf and name it as the workbook name?

@Azam asGood day,
The below VBA code can help you solve the problem. Please have a try. Thank you.

Private Sub CommandButton1_Click()
Dim xSheet, xDWS As Worksheet
Dim xFNum As Integer
Dim xSRg As Range

On Error Resume Next
Set xSRg = Application.InputBox("Please select cell to paste the range:", "Kutools for Excel", xTxt, , , , , 8)
If xSRg Is Nothing Then Exit Sub

Application.ScreenUpdating = False
Range("A1:C17 ").Copy
xSRg.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.ScreenUpdating = True

End Sub

@Jessica Hi Jessica,
What do you mean box? Textbox?

@shade131fulGood day,
Thanks for your comment. The code has been updated in the post, please have a try.

@skyyangHello, i used the function above finding the row number in which the cell in the column is not blank.


But, I used the function for a column which has a function itself and the analog function doesn't function. Anyone can help me please?

Thanks.

This is another one of those things that ought to be more obvious but has probably been like this since Outlook 2000 (except for starting at the ribbon). I suppose Microsoft is afraid to change it now...

I remembered as far as the "Show Columns" dialog box and totally overlooked "Select available columns from..." (and then remembered that I forgot to look at that box LAST time too, perhaps a year ago). And every time I do it, I wish that Microsoft would default that box to ALL fields to keep me from wasting time NOT finding the field that ought to be there somewhere. (Surely Outlook's basic design predates the era of usability testing?)

That is my rant for today. Thanks again.

I second Jack's statement. How much time I wasted without knowing how simple it could be. Thank you!