BOBUEK-more help please!

G

Guest

Guest
Thanks so much for the code - Am pasting it here (thought I already sent this letter but I don't see it so I musn't have pressed submit)- It doesn't like lines 2 - 5. Are the underscores end of lines meant to be there? It also doesn't seem to like the colons/=.

Sub Activities()
If WorksheetFunction.CountA(Cells) > 0 Then
'Search for any entry, by searching backwards by Rows.
lastrow=Cells.Find(What:="*", After:=[A1],_
SearchOrder:=xlByRows,
SearchDirection:=xl(Previous).Row
End If
EndofList = lastrow
Range("A1").Select
ActiveCell.Offset(EndofList, 1).Range("A1").Select

End Sub

Now what do I do with the location= code you also included. Does that macro read the long one and then do it? If so, which one do I attach to a button, just the short one? Sorry to be so lame, am just learning all this and of course am in way over my head (thanks, Boss!)

Can you help me tweak this code? With the location= code you put, is that what I need and not a "select" thing? I am trying to select the rows of unknown number, then paste them into A1 of workbook B.

Grrr................. HELP!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top