MyRng.EntireRow.Copy _
wbTo.Range("D" & lDestLastRow)
You can't copy an entire row to column D as that would make the data go outside the worksheet.
Edit: Ha, guess this was already said
MyRng.EntireRow.Copy _
wbTo.Range("D" & lDestLastRow)
You can't copy an entire row to column D as that would make the data go outside the worksheet.
Edit: Ha, guess this was already said
You can also create an variable for the results of TextBox1 & TextBox2, set the variable to zero if the textbox is blank.
cells E69:F69 need to be merged.
Both have different data but they both are on the same row.
You can have both column A & B in the same listbox, in your properties, change to column count=2 and change the range to include A2:B4
Here is the code, it just needs to be in the Command Button
Try this.
The" exit for" is the line the exits the loop after the first occurrence.
The code does not open the workbook, that error should not occur.
If you are attempting to open the workbook in the code, search for "Open workbook if not already open"
I have a code that copies and pastes a rang to outlook, I thought I would try using the print screen and pasting into outlook and it seems to do it.
See how it works for you.
Give this a try,
If you have a PDF printer you can print the userform
I removed most of the information in the database due to confidentiality reason as it is work involved
Your workbooks should show the original layout and what the required results should be.
Fill the sheets with phony data.
Supplying blank workbooks is not helpful
Hello,
What is the code doing and is it running slow?
Supply a sample workbook to go with the code so somebody can test it.
You need to remove .select
I don't get that result, but if you are getting 1 more than you want, you can always subtract 1 from `num`, you will have to make sure x does not equal zero though . Probably changing
if num>1
You don't want
for x=1 to 0
You have it copying e20:I34 but the range should be E21.
E20 is blank, so the code will keep pasting in the same cell.
Changed so cells don't get cleared.
Ya activeX controls suck when hiding and unhiding rows.
Here is attached, I have removed the command buttons and gave a couple options using shapes,button from forms control and actually assigning the macro to the phone.
Click the button,Shape or phone.