Select and Show the Selected Cell, Row or Column

[rakotonirinas]

Hello,

I have a worksheet with a long data which fills the Range("A1:DG4600"). As result, I won't be able to see all this data on one screen unless I zoom out the whole sheet.

So I ran a macro to lookup matching value (if exists) and take me to that row by selecting it. The issue is that when the macro is executed, the row is selected but it doesn't take me to that selected row, unless the range displayed on my screen is the same range where the selection is.

What should I do to have the selected row displayed on the screen, in other words, for me to be taken there so I can have a look at it?

Thank you very much.

Please Login or Register  to view this content.

[TMS]

Use Application.GoTo

[Fluff13]

Alternatively use

Please Login or Register  to view this content.

[rakotonirinas]

Thank you Fluff. I did use this but somehow it superseded the Activate function of the worksheet on a specific cell every time I switch to that worksheet.

[Fluff13]

Sorry, but I don't understand what you are saying.

[rakotonirinas]

Sorry, but I don't understand what you are saying.

I have the following code on Sheet1. Every time I switch (open) that worksheet, it always go to (select) the last row on the column G. And now, it no longer does it after I used the 'Activate' statement.

They may not be inter-related but yet, somehow it doesn't work when I use that one. Thank you.

Please Login or Register  to view this content.

[Fluff13]

Do you want the the last cell in col G to be selected,or the row that you found?

[rakotonirinas]

Do you want the the last cell in col G to be selected,or the row that you found?

Well, it's a bit complex. I would like to have the last Cell in col G to be selected every time I switch to its worksheet. However, when I run a macro, that will lookup for a match from a userform textbox, if it's a match, then I would like to go to that matching row on the data.

[TMS]

Did you see post #2? And, if you did, have you tried it?

[rakotonirinas]

Did you see post #2? And, if you did, have you tried it?

Hello TMS,

Thank you for your suggestion. I did but I probably did it incorrectly as my understanding is I have to create a label for it to function. Can you enlighten on where should I have the GoTo statement?

Thank you.

[nigelog]

Please Login or Register  to view this content.

[TMS]

Nigel has given an example. This is Application.GoTo which goes to a cell on the worksheet, not GoTo label which goes to a label elsewhere in the code.

[rakotonirinas]

Hello,
I used the Application.GoTo as per below (hyphenated now) but it didn't go to that particular cell. Somehow with the .Select, it is working but the issue is if let's say I am in the bottom of my data then I will have to scroll up to where it is selected.
What other options I may have?

Please Login or Register  to view this content.

[TMS]

You need the last parameter to be True

See: https://docs.microsoft.com/en-us/off...plication.goto

Please Login or Register  to view this content.

[rakotonirinas]

I haven't managed to make this work yet but I'm sure it is the correct thing to do. I have kept the

Please Login or Register  to view this content.

one for the time being. I think it got something to do with earlier code I used which probably clashes with this GoTo.

Will update when I found out the culprit. [will keep the post open for the moment]

Thank you.