Search results

Hi, Can anybody crack this...!!! I have 2 columns in Excel 2003. The rows of column A contains some text which is the same as the rows in column B, except for few differences. Eg: Row 1 of col A: This is a test line Row 1 of col B: This may be a test line I have many rows of such kind...

I couldn't get through clearly, but (presuming that you want to send the application as an attachment through email) if you can use some code in VBA which displays an input box prompting you to input the desired spreadsheet name which after clicking OK ... 1. Hides all the other spreadsheets...

You can actually use this code: Here I have used Sheet1.cells(1,1)....but you can use your own spreadsheet name and the cells that you desire to.... With this, the focus of the cursor goes to the desired cell when the commandbutton is clicked besides performing all the actions that you have...

Hello....ppl..!! Somebody please tell me what OFFSET does... I have some problem.... Have data (say column 1 has codes, each code would have multiple data in another column (column B) and each entity of column B has multiple (and sometimes redundant) data in column C. I have used OFFSET...

Try with SetFocus

And Kudos to you....This works very well... Thanks a lot...!!! :)

Wow..!!! that's really a cool method chergh ....:cool: You simplified it to a maximal extent:)

A vague idea that I have is: write a For...Next loop (or For Each...Next loop) to see if each cell is blank or not....If any cell is blank, the loop must terminate and copy the data from the cell above it to the beginning (i.e., the cell from where the data is starting) and paste it in another...

Thanks for the response chergh. Would try..!!

I have an event in VBA: CalcVal_Click() dim startdate as date dim i as integer startdate= date(month) & "/" & 19 & "/" & date(year) For i = 2 to 20000 If sheets("Data").cells(i,4).value="" then Sheets("Measure").cells(i,2).value=Empty Else Sheets("Measure").cells(i,2).value =...

=SUMPRODUCT((A2:A65536="No scan date")+(A2:A65536= "Arrival date")) This would solve the issue.

Have to tried SUMPRODUCT..??

As BobLarson said, use docmd.Transferspreadsheet Write it as code or as a macro and assign it to a click button, if you have a Form in Access...

Yes you can include the timer...but it works well with Excel 2007..not sure about 2003...still give it a try. This has to be done in VBA Sub Timer() Dim AlertTime as date AlertTime=now+timevalue("0:00:05") application.ontime AlertTime, Procedure: "closebook" end sub Sub closebook() msgbox...

Dont know how far am giving you the right information, but you can write a loop (mostly FOR...NEXT loop) to resolve the issue.. like: Dim i as integer For i = 1 to 20000 YOUR STATEMENTS NEXT (here i = 1 to 20000 refers to rows: row number 1 to row number 20000 of the rows in datasheet.)...

Thank you mailman for the prompt response....

Hi mailman, Could you explain it more clearly.. I meant to say....if there are macro cells as well as formulated cells...(say, some formulae written as in macro environment, such as [startdate]-[enddate], etc..and some functions that are Excel built-in have been used in a conventional...

Thank you mailman for your quick reply. However, please tell me if sql query runs effectively in Excel, for I have tried sql in Access VBA but not Excel VBA. And, I have both the data spreadsheet and table spreadsheet in a single workbook....(say sheet1 and sheet2 of the same workbook)

I have a database in one spreadsheet and table on another spreadsheet. The database would have the data of all the months.... There would be a field named TAT (which is a number) The fields required: Month TAT Centre (centre is an area of work, say Birmingham, Yorkshire, etc.) So, I want...

Is there any way to protect the formulated cells and still run a macro which results ultimately in the change in values in those cells due to dependency on the macro results..?? Or is it better to write all the formulae in the VBA environment, by which no formula is visible on the cell and...