Have copied data paste below occupied cell in Column A (offset)

[Pophil]

I have a macro that copies data from a new worksheet then pastes it into my main workbook. Here is part of the macro I have. How do I make it so it will paste into the first free cell in column A. Also some of the data even though it is just a number has a hyperlink attached to it. When it pastes to my main workbook the hyperlink is not attached. Is there a way to have the hyperlink paste as well with the number.


ActiveWindow.WindowState = xlMinimized
Call LMFDDMACRO


Selection.Copy
ThisWorkbook.Worksheets("LastMile").Range("A3").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
ActiveWindow.Close SaveChanges:=False
ActiveWindow.WindowState = xlMaximized

 

[Coyotex3]

Try changing this line from

ThisWorkbook.Worksheets("LastMile").Range("A3").PasteSpecial Paste:=xlPasteValues

to

ThisWorkbook.Worksheets("LastMile").Range("A3").end(xlDown).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

 

[Pophil]

Try changing this line from

ThisWorkbook.Worksheets("LastMile").Range("A3").PasteSpecial Paste:=xlPasteValues

to

ThisWorkbook.Worksheets("LastMile").Range("A3").end(xlDown).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

Thank you that worked. Is there any way for the hyperlinks that are linked to certain numbers in my data to paste as well. Example here is a number that gets pasted. In the temp worksheet the hyperlink works but when it gets pasted to my main workbook it no longer works.

3026110946601348098801843240111

 

[Coyotex3]

Hi Pophil, that is a new question and one I'm unsure how to answer. I suggest you start a new thread for more visibility since other might be more familiar with Hyperlinks. But maybe this c an be resolved by using something other than xlPasteValues. Maybe using xlPasteFormulas if you are using the hyperlink formula.

 

[Pophil]

Will do thank you

Hi Pophil, that is a new question and one I'm unsure how to answer. I suggest you start a new thread for more visibility since other might be more familiar with Hyperlinks. But maybe this c an be resolved by using something other than xlPasteValues. Maybe using xlPasteFormulas if you are using the hyperlink formula.Will

 

[smozgur]

Thank you that worked.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.