Return To Last Location

Jul 6, 2007

How do I write a VB Script to take the user back to where they came from.


User is on Sheet 1 and clicks a macro that takes him to Sheet 10.
I need a macro that is on Sheet 10 that takes the user back to Sheet 1.
BUT if the User is on Sheet 5 and clicks on a macro that take him to Sheet 10
I need that same macro on Sheet 10 to take him back to Sheet 5.

View 14 Replies


Save & Return To Last Location

Jun 9, 2006

User selects 'go to page B' on page A. They look at an object then click the object to go back to page A. Once back on page A they need to check data on page B, but in the same general location as where they just looked. This is over simplified, but pretty much sums up what I need to do. The code I have now is below, but keeps sending me to the last selection on my current page.

Public Sub SaveLocation(ReturnToLoc As Boolean)
Static WB As Workbook
Static WS As Worksheet
Static R As Range
If ReturnToLoc = False Then
Set WB = ActiveWorkbook
Set WS = ActiveSheet
Set R = Selection
End If
End Sub

Public Sub SetSaveLoc()
SaveLocation (False)
End Sub

Public Sub GetSaveLoc()
SaveLocation (True)
End Sub

View 2 Replies View Related

Return Cursor To Last (previous) Location

Dec 30, 2008

I am familiar with the codes suggested here:

I move the cursor with Hyper-Links or just by clicking another cell.

I wonder - is there something I can add/do in order to enable returning from ANOTHER sheet !?

View 10 Replies View Related

Return Active Cell's Location/row

Apr 9, 2009

I'm having trouble identifing a way to return a location for the position of the active cell. I've searched Excel help with "Position, location, return, activecell, etc." and I can't seem to figure this out. I know that it's possible, so that's why I'm on here!


Ok, say the active cell is currently "F1", and I need the location "F1" to identify the ROW to be used in a formula later, how would I go about that?

The current contents of cell "F1"' will be "REPLACE", but I need to change the words "REPLACE" in "F1" and other cells labeled "REPLACE" in column F to the following formula (where the "1" in "A1" is is the current row):

View 9 Replies View Related

Search One Column For The Location Of That Value And Return The Row Value

May 8, 2008

I have a value stored in variable A. I need to search one column for the location of that value and return the row value. there is no chance for a duplicate entry. Is a loop my only option, or is there a find command in VB?

View 9 Replies View Related

Return Cell Location: Of Several Items

Aug 27, 2008

I would like to return the cell location of names in column A as they are located in columns B and C, and return the locations in column D....

View 9 Replies View Related

Find Address And Return GPS Location From Another Sheet

Jun 3, 2014

I have a table with customers and their addresses (sheet2) and I need to find their GPS locations in sheet1.

I guess the logic would need to be something like this:

find CityName and StreetName in sheet1 where StreetNo is between minStreetNo and maxStreetNo return GPS X and GPS Y

with the formula or VBA code?


View 2 Replies View Related

Excel 2007 :: Search Box Function - Return Value / Text Not Location

May 15, 2014

I need code for a search box function, that returns the information recorded in a cell for example, "Barcelona" or "London" etc), instead of the location of the cells.

I will need to narrow it down to search only the information in the following columns:


I am totally new to VBA coding and have stumbled my way through a few things, but everything I have searched for so far has had at least one error when transposing to Excel.

I am running Excel 2007.

View 3 Replies View Related

Interpolation Given A Variable Table Location & Location Of Data Within

Oct 6, 2009

I am trying to develop a spreadsheet that will calculate a cost based on a matrix. I am attaching a sample of the calculation created so far. The end result is in cell M13 and is highlighted in yellow. I kind of layed the formula out in a few different cells, so hopefully it would be easy to follow.

simplify this process with maybe another formula that I might not be aware of, or maybe show me how to get this done in VB code. I think VB code would be the correct way to go just not sure.

View 6 Replies View Related

Formula To Return A Cell Location Not Cell Value?

Jan 31, 2013

Is there a standard way across all Excel formulas to have the cell location returned rather than the value of the cell itself?

In other words A33 instead of "52" (with A33 being the cell that contains "52")

View 1 Replies View Related

Vlookup And Location...

Mar 10, 2009

I have a VLookup function setup but I would like another function to tell me where in the table array the value is located.

View 2 Replies View Related

Lock Tab Location?

Nov 16, 2011

Is there a way in excel to prevent someone from "re-ordering" tabs in a workbook without using a macro?

I am using a sum formula that goes across multiple tabs, but noted when I rearranged the order of the tabs, that the results of the formula changed. After some minor research, I noted that I had moved a tab outside the "sum range" inadvertently.

View 1 Replies View Related

Defined The Location

Oct 10, 2007

If Worksheets(FirstSheet).Cells(Counter, ColtoMove) = MoveIf Then
'i didn't add the THEN PORTION becasue it errors at the above statement.

the problem is that when i go to the defined location (Worksheets(FirstSheet).Cells(Counter, ColtoMove)) it shows the correct/or same PO number as when i put the cursor over the "MoveIF"....this leads me to think that it should not error.

Could it be a correct statement to say how the MoveIf is defined?

I have added a list of all of the potential values that can cycle through this statement.

how these entries could cause a problem in the above code? I am trying to keep it simple (outside of the long list below that is)

PO Number

View 9 Replies View Related

Reference Location

Jan 13, 2010

Is there a formula that will return a specified location (column and row) for a text item within a worksheet?

View 9 Replies View Related

Saving In More Than One Location

Jul 22, 2006

I would like to create a button on a toolbar to save my spreadsheet in 2 locations (always going to be the same, just the file name will change).

View 5 Replies View Related

Allow Save As With Different Location But NOT Name

Aug 26, 2006

I have the following code allowing the user to save a file using a custom macro button. However, I do not want to let them change the name of the file, just the location. How do I do this? ...

View 9 Replies View Related

How To Know Location Number Of Min Value In Range

Mar 31, 2014

A1 cell: 9
A2 cell: 6
A3 cell: 2
A4 cell: 4

i want to know location number of min value in range[A1:A4].

the result: 3

View 7 Replies View Related

Adding Numbers Together That Are From Same Location?

Dec 31, 2013

I attempting to develop a forumla to account for 50 locations I am responsible for that will add different numbers together based on a specific location.

For example, if the location says "Los Angeles", I need the formula to look for all instances of "Los Angeles", the quantity of items sold and add them up for me in one spot.

View 3 Replies View Related

Offset From Location Of Another Cell

Jan 15, 2014

Is there any way to use the offset formula in reference to the location of another cell?

Here is a simplified version of my problem:

Sheet1!A1 refers to Sheet2!A1.
Sheet1!B1 refers to Sheet2!D1.
Sheet1!C1 refers to Sheet2!E1.

Is there any way that I can say that Sheet1!A1=Sheet2!A1 and then use the offset formula based on the location referenced in Sheet1!A1? The cells being referenced are merged cells one column wide and varying rows long, so there is no real pattern to follow except that the corresponding cells (the ones that I want to use the offset formula on) are all taking up the same amount of rows and are an equal amount of columns over (Sheet1!B1 refers to 3 columns over from Sheet2!A1, Sheet1!B1 refers to 4 columns over from Sheet2!A1). The spreadsheet is a fairly complex one and it would be much cleaner and less likely to have any mistakes if I was not referencing each cell individually.

View 2 Replies View Related

Excel Backup Location?

Mar 29, 2006

Excel has a function, everytime when I save the file, it will create a backup. how could I specify the location for my backup file?

View 8 Replies View Related

Default File Location

Mar 26, 2007

I have had my server removed that I had my default file location, when I go in to change any of my options the first thing it does is go look for this file location and brings back an error stating it cannot find the server. I cannot find anywhere else that I could change it.

View 9 Replies View Related

Move Every Second Cell To Another Location

May 20, 2014

I have received a spread sheet with all the data in column A. It follows the format of A1 = Name, A2 = Email, A3 = Name, A4 = Email, etc. for over 800 entries. What I need to do is etract all the email addresses and place them in column B alongside the Name. I don't have any experience with Makros and tried to use one but kept deleting the wrong data.

View 5 Replies View Related

Search For Name Within Many Location Tabs

May 27, 2014

Attached I have my document that I am trying to create a search engine for. I want to be able to search for a name within many location tabs. I want to be able to search by name only, bring over the information, and be able to jump to the persons name. If at all possible i would like to be able to search for all that have been billed but not paid.


View 1 Replies View Related

Popup Calendar Location

Jul 4, 2014

I followed this guide for a popup calendar

How can adjust this so the calendar popups to the right of the cell thats called it. At present it just pops up in the middle of the screen.

View 1 Replies View Related

Sheet Not Saving To Location

Feb 3, 2014

In the attached sheet in module5 I have a save macro with this code

HTML Code: 

ActiveWorkbook.SaveAs Filename:="D:Picking Logs" & _
Replace(sFile, "/", "-"), FileFormat:=52

-This saves it to my computers D drive and works fine.

Then I also have the following code whice is suppose to save it to the public drive which is U: drive, but this computer does not have direct access that that drive so i save it to

HTML Code: 

ActiveWorkbook.SaveAs Filename:="wcrsan1
owley public1 picking logs" & _
Replace(sFile, "/", "-"), FileFormat:=52

-The wcrsan1 is the path i use to save it to th U:drive.

My issue is the code runs fine, but it does not save it to wcrsan1 owley public1 picking logs. If i save it manually it works but not when the macro runs it.

VBA is password protected.. The password is Kayley98 the sheet password is go


View 2 Replies View Related

VBA To Create Pie Charts For Top 10 Of Each Location

Feb 23, 2014

Basically I want to have a macro to loop through and make all the pie charts for each location but only for the top 10 of each location.

I also want the legend to be more precise for example, for London the first one in the legend should show:
Column C + "-" + Column I + "-" + Column J

Which would be: London - Rol9 -13

Instead of it being: London data rol9 13

Attached is the document in question where I've made the graphs manually : Example_Pies.xlsx‎

View 3 Replies View Related

Saving In Wrong Location

Sep 25, 2006

I have the following code which saves my worksheet with a name extracted from particular cells:

Public Sub SaveAsMaximoWO()
ThisFile = Range("AC5").Value
ThisFile2 = Range("E3").Value
saveName = ThisFile & " - " & ThisFile2
ActiveWorkbook.SaveAs Filename:=saveName

End Sub

This (for reasons I don't understand) saves the file to My Documents by default.

What I would like it to do is save to another folder within my documents as default.

View 14 Replies View Related

Copy A Picture From On Location To Another On The Same HD

Jun 8, 2009

First of all, I would like to thank all Excel Forum Moderators and Members especially Andy Pope for the great effort they exert to help all members.

Lately, I viewed the thread available on the following link and I admired the great perfect work and codes provided by Andy Pope so much,

My request is similar to the points discussed in the above mentioned thread, but, it is a little bit different ..

Instead of inserting the picture to the worksheet, I want the picture to be copied from one folder on the HD to another folder called (Employees photos), which is located in workbook's path.

In other words, I need a code to copy one jpg picture from one location to another.

View 6 Replies View Related

Default GetOpenFilename Location

Sep 10, 2009

I have the following code, is it possible to direct to a default directory that the file might be in? So when I open the dialog box it will automatically redirect a directory that is stored in VBA.

View 4 Replies View Related

Insert Row At Variable Location

Dec 3, 2009

I had a quick question for something that should be simple but I can't figure it out. I have a column of sorted values, it goes


and I want to insert a row to separate the A's from the B's. But there will be a random number of A's. I can figure out how to count where the A's end. But I can't figure out how to insert a row. Any suggestions? I tried the two below but they don't seem to work. The for section is counting the A's, and it works, it's what comes next that's giving me a headache!

View 2 Replies View Related

Copyrights 2005-15, All rights reserved