Search results for query: *

I've tried your code and it seems to work OK. I select some text and run the macro and it put spaces in. What dialog box are you speaking about? What exactly is the problem?

Hello, If you want to use Excel function you have ISBLANK() and SUMIF you can look into. Personnaly I always prefer to work directly in VBA, i.e. create a procedure to do the work. in this case, you loop through your column, keeping a running positive total and a running negative total and...

Well I am not completely sure I understand properly, bu if I do, you need to insert a userform in your VBA editor. Put a field for the date and drop down menu with your options and a start button. Your macro first shows your form. User inserts date, select the option then click on start. The...

Well it seems knifey wants to do it programmatically which seems to me a good move. To give you an idea, you i2.value is not really going to work. If myRow is a row number (integer) and mycol is a column number, you can refer to the value of a cell using syntax like...

Hello Beginner999, First of all if you have a whole load of rows I wouldn't advise you to create your data on the same sheet replacing cells etc. Keep your initial data on one sheet. Create the result on another one. Then indeed forget the autofill and go into programming without selecting...

Thanks Adam, exactly what I was looking for! Cheers mate.

Hello, complete newbie for javascript and web stuff in general. Here is my question. I have a function that creates a table based on the values in a array. I use things like ... newRow = document.getElementById("myTable").insertRow(1) newCell = newRow.insertCell(newRow.cells.length)...

THanks Chantey. Was simple indeed but if you don't know you don't guess! Have a nice one.

Hi there, Absolutely new to XML. Have written a basic XML document and Basic DTD. When I visualise my XML in Internet Explorer, I know it first checks the DTD (because I had a mistake in it and it gave me an error message). Now I fixed the error in DTD and IE displays my XML OK. However if I...

Hi, I am new to dreamweaver and it doesn't start too hot. This happens within windows 2000, with dreamweaverMX or as well MX2004. I am just trying to register a local site (the sample site from the tutorial actually) and the Site definition dialog box doesn't appear. Instead I have an error...

That's really great of you to take time to test that stormbird. I couldn't believe it could happen that often, though! Will leave it as it is and not worry anymore then! Thx again Nath

Good idea, thx. Try www.macmusic.org, and select english. With my browser, I get an error message saying "Access id denied", and when I debug I am within javascript code at the following line: [code] parent.document.all[frame.name].width = 468 [code] And you?

Hi Stormbird, I don't think it is the browser. I didn't mentioned it in my body message (sorry), but in the title: it's Internet Explorer, so it would definitely be taken into account. I don't think either my software removes anything from the script, but isn't it possible that the dll (or...

Hi there, Not a javascript programmer problem, but more user problem. Hope someone in this forum can help me. When I browse on the net, I often get error messages. If I debug them, I realise they always take place within javascript code. It happens too often and on too many different sites for...

Hi, what you are looking for is Range("B14:F100").Cells(1, 1).Address Nath

I'm on Windows NT4, and tried it on Excel 97 SR-2 (j) (didn't try on VB6 as this is a VBA forum). I agree it is frustrating to have to use workarounds on things that should be working ... but I'm afraid that's often needed with our friend microsoft ... Let us know how you are getting on. Nath

Hi James, I could replicate your problem, .. except that even with the multiselect single it doesn't work! However the MouseDown event works. Could you use that? Nath

Sorry was writing answer at same time as you Neil. Well according to me, the way a date is interpreted in a cell is the same as in VBA and depends on the regional settings, and the way it is displayed is a simple matter of formatting. I did the following test in regional settings UK: In the...

Well Neil, it all depends when and how the user passes the date. Is it through a textbox, a text file, something else ... do you have any access to it before it gets to your function? You must have access to the first entrypoint somehow, otherwise it is too late. If you feed a date in your PC...

Hi there, you have to create a command object with a stored procedure command type, then create a parameter object for each parameter you have and add it to you parameters collection of your command object. Then associate the value to the parameter to the command object and execute the command...