Search results for query: *

Hi, thanks for looking I need to plot data from a spreadsheet. At present I have: A cell eg F1, with series name (part No) in it A cell eg F3, with an X value (A statistic relating to a batch) 20 Y values, in cells F6:F25 (measurements for the batch) I have 8 series at present (in 8rows) but...

Cheers skip. That did it after a few alterations. I had to step r inside the J loop and define the Xvalues and Values individually but its working really well now. I'd like to challenge the averaging now which I do believe will be a git. I've inserted some example data below. The data is in...

Hopefully that title was clear. I have loads of test data in a sheet. Its in pairs of columns for each series: A=Freq1(x1) B=Amp1(y1) C=Freq2(x2) D=Amp2(y2) E=Freq3(x3) etc What I need to do is get charts for every 5 pairs of columns so chart one has 5 series. BvsA DvsC ... JvsI Then another...

Thanks Loomah That worked and I have a lovely collection of data in my worksheet now. I now need to make charts from the data which I'm also stuck on but I'll make a new post for that. Matt [thumbsup2]

Thanks for that Loomah. I'll give that a go and let you know how I get on. Matt [hourglass]

Hi there, it's a long time since I last posted on here, I hope the forum's still as good as it used to be. I have a load of test data files with a standard file name format. "baXXc*.DFT" and I have to copy some data from each to an excel workbook. XX is a number that increases with each test...

Hi Im pretty new to Adobe Acrobat so please put any answers in idiot proof form. I'm using version 5.0. I have a number of scanned documents, some containing hundreds of pages each, and I have to apply a copyright statement to the bottom of each page of each document. I've worked out how to...

Fandabbydoosal Skip The repetetiveness level of my job has just plummeted. The code does just whats required of it. Many Thanks [flip]

Thanks for that Skip It works and even adds a footer if one doesn't exist which is something I needed but forgot to mention. Unfortunately I forgot to say it needs to be smallprint though. Fontsize 7. Would you be so kind as to let me know how to do this with the code also. Something to...

Hi There A question relating to Word, this one. I have masses of Word documents in a database and have been given the gripping task of adding a copywrite statement to the bottom of every page of every document. The database is Lotus Notes based so I guess I'll have to detach each file one by...

Hi there. Long time no thread. But i'm stuck again. I have an array that has been filled with strings. They are the result of an: Application.FileSearch.FileName = Blah\blah\blah\*.xls The wildcard means I get hundreds of FoundFiles. The bit that the wildcard represents is a string...

Hi Again guys. Thanks for the code combo, it does what its mean't to do like a dream, however I still need a little more help. In answer to the questions from Zathras. I don't want to hide the data, just protect it from alteration. I don't know how i'm going to access the data after the...

Hi there Not sure if this is possible but it's gotta be worth asking. I'd like to put a command button on a sheet which, when clicked, locks a load of option buttons, text boxes and some cells. Protecting the sheet so that the next user cannot alter it (it's a questionnaire and the customers...

Cheers Mike Short, sweet and helpful with more than just this problem. Just how I like them. I also couldn't get anything resembling help from the help files on this so a star is in order. Matt [thumbsup2]

Hi Everyone I'm looking to run some code following a double click (or right click) on a worksheet. Thing is I don't want to run it 'Before' the normal double click event handler. I want to run it 'instead'. Is there a way of doing this eg, by writing some code in the BeforeDoubleClick Event...

Cheers guys. Sorry for the delayed reply but I finished work and have only just started again. Between the selection of answers I patched together an understanding and ended up with. If Intersect(Range("RangeName"), Cells(Target.Row, Range("RangeName").Column)) Is Nothing...

Okay. Thanks everyone Your enthusiasm is overwhelming but i'm not quite getting why it needs this bit for Range2. If i put in: Range(("RangeName").Column & Target.row) it doesn't work. Am I missing the point of the NamedRangeColumn bit. I was expecting range2 to just be Target.row...

Hi there An easy one hopefully Is there a simple command to check if a given cell is within a named range? I want to write event handler procedures that will only be executed when the Selection_Change is to a cell that is on a row which intersects with a range. The range in question covers a...

Rock and roll Cheers Rob. Just what I was after. You are a star, and a star you shall have. [thumbsup2]

Hmmm yes. Sorry Skip, A bit of clarification might help. Both ranges will have the same name so I can use the name in the destination sheet to identify the range in the source sheet. Hence making it easy to do lots of ranges with a loop. I'm working from the destination sheet, opening a...