Search results for query: *

PHV, Hi, trying to use an IF statement but haven't done one altering graphs before, I think the structure is wrong. Do you think an IF ELSE would be easier? Thanks John Range("L284").Select ActiveCell.FormulaR1C1 = "=IF(RC[-1]=TRUE,&quot...

Hi, I'm having a problem creating the VB code which formats the colours in a graph depending on the outcome of another cell. Or to be able to format the graph to begin with to react to values on a conditional format basis. Would appreciate the help. Thanks john

Topjack Thanks When I open the two spreadsheets that are linked via the \\ATL05 the link does not shorten itself within the cell as per usual when a linked file is open. It also does not automatically update. Have you had this problem on your servers? Is it a glitch within excel? Thanks John

I am having a problem with links between different excel files on different servers. The links revert back to the pathname of the server when I open the spreadsheet. The linking of updated date is then inconsistent. e.g K:\excel.xls becomes \\atl05\finance\excel.xls Has anyone seen this...

Loomah, Brilliant thanks, it worked perfectly. Cheers John

I am trying to use a macro to copy a .pdf file and then paste it to another directory. Is it possbile with the usual VBA? Thanks John

Thanks Hasit, The formula used =INDIRECT("'C:\["&filenameA&".xls]"&"sheet1'!a1") I am having problems with the linking, They do not seem to be permanent links and when filenameA.xls is closed, the return cell changes to "#Ref!". Is this because the...

Hi, Is it possible to use this code for linking between files? i.e use cell "A1" as a variable for a filename? e.g A1 = "file1" C:\documents\file1.xls hope this makes sense. Thanks