Recent content by waynerenaud

Thanks for the lightning quick response xlbo, works fine with the other workbook open :-)

I want to use the indirect function to obtain data from another workbook on the network. workbook on my pc = local.xls workbook on server = P:\test\server.xls (P: is a network share with all necessary permissions) server.xls has 3 worksheets named QLD NSW VIC cell A1 in QLD = 5 cell A1 in NSW =...

Its ok guys - I have fixed it. For interest: It had lost the vba reference to the microsoft outlook 11.0 object library. Re-added the reference and everything is peachy again :-)

I have some code that I have been running everyday for over a year. Yesterday it started erroring. (Nothing new installed, nothing has changed in our environment) the only thing I can see different is windows update has loaded some SP2 hotfixes (I do not have SP2 installed). I have not tried to...

Try this: Sub Macro1() Dim StartRow, EndRow, SelectionArea StartRow = ActiveCell.Address EndRow = ActiveCell.Offset(98, 0).Address SelectionArea = StartRow & ":" & EndRow Range(SelectionArea).Select End Sub

Hey gjd, I thought you deserved a star, 1 for giving yourself some great help, and 2 for updating your post so that we could all benefit. Your code will help me with a couple of issues I've had. Thanks :-)

Try putting this at the beginning Application.ScreenUpdating = False Dont forget to put this at the end Application.ScreenUpdating = True

Back at work now :-) this is what I have so far, which will open ppt and select slide2. Sub Open_Powerpoint() Dim pptApp As PowerPoint.Application Set pptApp = New PowerPoint.Application pptApp.Visible = True filetoopen = Application.GetOpenFilename() 'choose the powerpoint...

f64 - I want to do exactly the same thing. I started writing some code today at work (cant access it because I am at home now). I have only managed to get as far as opening powerpoint and selecting a specific slide using slide1 slide2 etc so I would be interested to see any code you have so far...

Right click on your chart and choose copy. Or..... In excel2003 (don't know if this works on earlier versions) click on your chart so that it is selected, then hold down the shift key and click on the menu option Edit, you get an extra choice of copy picture. This will copy to the clipboard and...

Try in cell B4 =RIGHT(D6,5) then fill down as required or look at =cell("address") or the INDIRECT function Hope this helps

Hi PWD, I cannot work out what you are trying to do..... I figured you need "z" in cell F2 and "Stockcheck" in cell G2. What are you trying to do from there ? Selection.End(xlDown).Select will select the next data entry in the current column, in your case column G, so if you have an entry in G3...

psalm6229 what do you mean by "I want the Value in M11 to be linked to ....." ??

Another way to skin a cat..... put 1 in cell A1 then choose edit/goto under Reference put A2:A3000 click ok then type =A1+1 and press ctrl + Enter

If I have understood your question correctly, you need to save them in personal.xls. If you dont have personal.xls go to tools/macro/record new macro in the window that pops up choose personal macro workbook from the dropdown. You can then copy your modules/macros into personal.xls which can be...