Hi,
I'm new here, I just to ask if this can be done in excel, because in msword the jumping of page is possible.
How this can be done in excel?
Hi,
I'm new here, I just to ask if this can be done in excel, because in msword the jumping of page is possible.
How this can be done in excel?
Last edited by blaisexena; 06-16-2013 at 04:16 PM. Reason: theres no need of the code
Deleted. As I think I am miss-interpreteting the question
Last edited by WasWodge; 06-16-2013 at 02:13 PM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Try the code below if you are trying to go to any page randomly on the same sheet. Change 3 to the total number of sheets.
![]()
Sub test8() Dim i As Long i = Int((3 * Rnd) + 0) Cells(1, 1).Activate ActiveWindow.View = xlPageLayoutView ActiveWindow.LargeScroll i End Sub
Last edited by WasWodge; 06-16-2013 at 06:06 PM.
Hi,Try the code below if you are trying to go to any page randomly on the same sheet. Change 3 to the total number of sheets.
I'm only using sheet1 and sheet1 is the page I am jumping to get any image like pictures, but I already managed to get the pictures, what I want is to jump in any page of excel sheet just like what I did in msWord.
I'll try the code,
thanks
@WasWodge
I have get what I want, it points me to the other websites while searching a keyword from your code("xlPageLayoutView"),
and the other websites was not actually what I want, but part from it to get what I wanted to.
I'm now using for each statement to loop what pages I want to scan pictures of excel.
Thank you.
Last edited by blaisexena; 06-16-2013 at 04:21 PM. Reason: grammar
Happy you seem to have found a solution.
By the way
is a typo. It should readChange 3 to the total number of sheets.
Change 3 to the total number of pages.
thank you![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks