Recent content by NIWANut

You beauty SkipVought, that is brilliant[2thumbsup] George

Hi, I want to know if I have a named cell e.g. A1 is Named as "AValue" and holds the number 33.6. So in a formula if I AValue I get the number 33.6 Now if I have A2 holding "AVa" and B2 holds "lue". If C2 has the formula "=concatenate(A2,B2)" the result in C2 is "AValue" as text. Now the...

Hi, Does anyone know of a library package or similar that will allow me to convert and save jpeg images into PGM format using VB6? Thanks George

Hi Vampire and JoeAtWork, Thanks for your suggestions that worked, just me being a little thick, perhaps the days are getting too long. This resource is fanatastic and guys like you certainly make it what it is. George

Hi, I used your code in thread222-1000041 but I get an error on this line COMMData.NewDataString = S in Private Sub MsComm1_OnComm() ' this sub fires whenever new data has arrived at the Comm port Dim S As String S = MSComm1.Input ' send this new string to the COMMData class for assembly...

Hi, Thanks, turns out I found the error. I had created a variable with the same name as a control on my form. George

Hi, Suddenly one of my databases which has forms produces an error when ever I use a control that has an event procedure attached. For example when I have an event procedure On Mouse Down and click on it, I get "The expression On Mouse Down you entered as the event property setting produced...

Hi, I want to insert an image in an Excel workbook so that each time the workbook is opened the image is refreshed so that I get the latest version of the image. I am sure this is easy but today has been long and obviously the mind is mush. Any help most appreciated. Thanks George

Hi, I have a spreadsheet that has many formula and decided it was better to name the cells used in those formulas with meaningful names. Presently they are in $C$R format. So having named the appropriate cells, I now want to change all the formula references from $C$R type to my Names. Is...

Thanks CubeE101, That sorted it. George

Hi, I am trying to develop an application and it seems as though all my projects are linked which causes them to all update each time I save the current project. What I want to do is to make a new version of my project by saving the present project with a new name e.g. if my present project...

Thanks for that clarification, I didn't realise that Require Variable Declaration was important when each module was created. But..., I have been unable to find Option Expilict in any modules in the workbook - that is my problem - there appears to be something else affecting it but for the life...

Hi, I have been given an excel workbook to check the macro coding and each time I run any of the macros I get an error "Compile Error Can't find project or library" on a line such as "ThisRow=2" if I declare the variable with a Dim statement the macro will proceed until the next variable...

Hi Gerry, Thanks for that, a nice little trick. George

Hi, I have a combo box on a Userform (initiated by clicking a command button)that I want to show all the names of the sheets in a workbook - no problem to achieve this - I added the names using AddItem on the Userform Initialise event, then I show the Userform. The inital value shown in the...