| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
Norma's code worked great...thank you for trying to help.
NickHK wrote: You could try some debugging yourself, to check the value returned at each stage. Correction: Mid(Application.ConvertFormula(ActiveCell.Value, xlA1, xlR1C1), Len(ActiveCell.Parent.Parent.Name) + 3) NickHK wrote in message ups.com... Nick, Check your code because it isn't working...I keep getting told that the refrence is invalid. It seems that even with the understanding that the workbook name is inserted once its converted it still isn't making a diffrence. I only want my macro to understand that it is to goto... Sheet: DB1 Cell: B65500 There for its "DB1!B65500" in the activecell.value ?????? Is there a pieace of code that converts the DB1!B565500 into the crappy refrenced format of "DB1!R[2]C[-13]" without having to actually change the properties of the cell, I mean even it does I can work around this but somehow my formatting has to be changed by the macro and since I never used the 'crappy formatting' then I am at a lost... NickHK wrote: You do not need to "put in the workbook name inside of the activecell.value". It is generated by .ConvertFormula and consequently must be removed to give a valid value for .Destination. NickHK wrote in message ups.com... Nick I like your way of thinking but that isn't working either...the [Bookx.xls] isn't in the activecell.value code and its not ever going to be...I simply want VBA to understand that it is to goto a specific area of the individual workbook and do something (which Ill program it to do) however the refrence error happens with your code...even when I put in the workbook name inside of the activecell.value... thanks for atleast attempting to slove the issue. NickHK wrote: <According to Help for .GoTo .....Reference Optional Variant. The destination. Can be a Range object, a string that contains a cell reference in R1C1-style notation,.... </According to Help for .GoTo So, you have to convert your address to the correct format and remove the [Bookx.xls] that gets added Application.Goto Reference:=Mid(Application.ConvertFormula(ActiveCe ll.Value, xlA1, xlR1C1), Len(ActiveCell.Parent.Name) + 6) I doubt this is the best way of achieving this, but it works. NickHK wrote in message ps.com... Hello fellow programmers! I am in need of some help trying to get my macros to goto a specific location from a sheet...I'd figure the code would look like this... Application.Goto Reference:="ActiveCell.Value" The problem is I am told my refrence isn't correct..however I have tried to format it the way it works when I use the "Goto" function of Excel (CRTL + G) the format I am using in the active cell is... SheetDB1!B65500 When I copy this code and use the goto function it works fine but the macro is failing to realize what it is I am trying to do...Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Whats the new "Template Wizard with Data Tracking"? | Excel Worksheet Functions | |||
| How to change "automax" to "autosum"? (probablyl wrong terminology) | Excel Discussion (Misc queries) | |||
| whats the big "Page 1" that appears across my spreadsheet? | Excel Discussion (Misc queries) | |||
| Application.Goto reference:="MyCell" | Excel Programming | |||
| Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...? | Excel Programming | |||
Threaded Mode
