-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
data.select
-
L
A Misbehaving Macro
I want the below macro to leave the user on cell A3 in the sheet "Crew Satisfaction Data" but for some reason it leaves the user on a different sheet ("Response Calculator") that isn't mentioned at all in the Macro. Can anyone tell me why and how I can fix it? Ewan :O)- laingy24
- Thread
- application.cutcopymode data.select macro selection.copy sheetstidied
- Replies: 1
- Forum: Excel Questions
-
T
Macro to filter by date in cell
Hi Everyone, Not sure what ive done wrong please help if you can. I want a macro to filter based on a data in cell M1 But my current code hides all the cells can someone help me or give me a new code that works please? thanks Tony my code Sub Get_Todays_Data() Application.ScreenUpdating...- tonywatsonhelp
- Thread
- code data.select lastrow sheetsall years
- Replies: 1
- Forum: Excel Questions
-
H
Macro to clear data
I have the folowing macro The data is only cleared on sheet "Imported Data" and not on sheet "All Data" Kindly amend my code Sub Clear_Data() Sheets("Imported Data").Select Dim LR As Long LR = Cells(Rows.Count, "A").End(xlUp).Row With Range("A1:AZ" & LR) .UnMerge End With With...- howard
- Thread
- data data.select end rangea1az sheet
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
