Prev: "Update" calendar on userform?
Next: Application.Visible=False
From: Norbert on 20 May 2010 02:47
Hi Ryan,

if I had formulas in my spreadsheet to retrieve data from a certain
spreadsheet (which is not open), like this:
=[7488.xls]Prod.ticket'!$AD$24"

How do I change the number 7488 to the content of cell A16 e.g: 7265?
So, I enter 7265 into cell A16 and I want the formulas to bring up the
values which are saved in 7265.xls

Norbert

On 19-05-10 15:36, ryguy7272 wrote:
> I'm not sure I understand what you want. But...take a look at this:
> http://www.rondebruin.nl/tips.htm
>
> Look under the section titled 'Copy/Paste/Merge examples'. See if there's
> something in there that may help.
>
> If you still need help, post back with specific questions.
>
>
From: Norbert on 20 May 2010 09:23
Hi Don,
I actually don't know how to do that. I can record a macro and do some
small changes but thats it.
Can't you give me a bit more details, please?



On 20-05-10 15:05, Don Guillett wrote:
>
> Use an edit/replace macro tied to a worksheet_change event restricted
> to that cell.
From: Norbert on 20 May 2010 09:47
I got only so far:

all my formulae have an entry [0000.xls]
I want to find/replace the 0000 with the content of cell A16, which
obviously changes.
That is my problem! The macro records exactly the content of A16 at the
moment I record it.
How do I have to change my code?

Range("A16").Select
ActiveCell.FormulaR1C1 = "4788"
Cells.Replace What:="0000", Replacement:="9725", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False


On 20-05-10 15:23, Norbert wrote:
> Hi Don,
> I actually don't know how to do that. I can record a macro and do some
> small changes but thats it.
> Can't you give me a bit more details, please?
>
>
>
> On 20-05-10 15:05, Don Guillett wrote:
>>
>> Use an edit/replace macro tied to a worksheet_change event restricted
>> to that cell.
 | 
Pages: 1
Prev: "Update" calendar on userform?
Next: Application.Visible=False