Recent content by barnard89

Hi With reference to the same problem this is the code what I have written I am randomly selecting the items( in the same column) and naming them as a range ( Range_1) The items are the ones that I had selected ( ie Selection.address ) I need to place the row numbers of all the cells that...

Hi PHV Thanks for the reply Now my Range in real world runs into some 8000 - 9000 rows So I am not in a position to write a code like For Each c in Range("A1,A5,A10,A14,A17") Debug.Print c.Row Next Could you kindly suggest a modified method Thanks in advance

Hi I have a range in an excel sheet. The row is always of a single column, but multiple rows How can I get all the elements of the Range into a Collection The Range can be continous like Range("A1:A15").Select or it can be discontinous like Range("A1,A5,A10,A14,A17").Select How can I...

Hi I have an excel sheet where in the user enters SSNs in the first row of the sheet But in case the user types in some value and presses Escape button , the user jumps out of that cell and leaves that particular cell blank, but i need some mechanism by which I can still record that event...

Hi I had defined a name called "Name1 " which refers to A1 : A500 in worksheet1 This is the code I am using Dim str as string str = "Name1" Dim Range1 as Range Range1 = Worksheets("sheet1").Range(str) msgbox Range1.name I expected to get Name1 as the result Rather it is giving me a...

anotherhiggins thanks a lot for your reply it works

Hi I have an excel sheet which has monthwise expenses each month expense is in one separate row. How do I calculate the running totals of those values in the adjacent columns Please suggest thanks

Hi Could some one please suggest me a way how to connect an Excel sheet to SQL Server database I wish to fetch the rows from Employee table into excel sheet I need to connect to Employee table in "Pubs" database. user id "sa" password "" I would like to connect using the concept of ADO. Can I...

Hi I am using Excel 2000 I have a workbook which contains multiple worksheets Each worksheet has only one column ie Column A (SSN ID). This Column is to maintain all the SSNs of the employees. All the columns A in all worksheets are only for SSN Normally all SSNs are supposed to be unique...

synapsevampire Thanks a lot for your valuable post

Hi I am new to Crystal reports . I am using Crystal reports 9. I have a report report1.rpt in C:\Data folder How can I call or execute this report from Visual Basic 6? Could some one suggest me the method or code for this thanks

I am using Access 2003 I have certain forms where I need to place text boxes to handle data with baout 2000 - 3000 characters long Ideally, in a Access 2000 environment , I would be using a Rich text box to handle this issue, but in Access 2003 I cannot use a Rich text box The general text...

I have Access 2003 loaded on my machine I have an application on a different machine which is in Access 2000 I have to compulsorily load that application in Access 2000 only as many of the components inside that application are not recognized by Access 2003 I need to view that Access...

Thanks How can I upgrade this activeX control? I am using a Rich text box as the ActiveX control

Herman What do you suggest would be the remedy to this? Thanks