I am writing a program and have the following code:
This works perfect but I have been trying to modify the code and have had issues. I have changed the A in range hoping it would search a different column to paste info too but it isnt working.
Also, I have a combobox and do a VLookup based on what is in that box. I was going to use a if then statement so I wouldnt get a error if the field is blank. If is field is blank what is its value?
One last question. If I wanted to use the copy and paste code before. Is there a short cut to pasting to a empty page or am I going to have to use if then statements?
Bookmarks