Recent content by kenguru

Hi, I have a general question about vba and if this can be resolved I will dig into it, only I want to make sure that this is possible. I have an excel which has some hyperlinks in the same column on different row. I have to click on each of them then take the info from the webpage which opens...

Yes this solved my problem. Thanks a lot for your answers !

I need to know which line contains data, because I have to create the following formula: C100 = Sum(C1:C50)+ .... - where let say that C50 is the last line containing text. I have to calculate the sum of the lines. But if on the sheet there are inserted new lines, than there will be more than...

Sorry for not specifying clearly my problem. I need the last line which contains data (=text).

Hi, Is it possible to calculate which is the last line in an excel sheet which contains date, using excel formula? I done this with VB script. For ex: A1= 1 A2 = 2 A3 = 4 A4= nothing A5=6 .... nothing lower ... And as a result i would need the A5 cells, because that contains the last data...

The "Runner" is defined later in the code. Maybe if yu saw this you will understand better my code: Private Sub Command1_Click() On Error GoTo Handler Call Hello End Handler: Call Runner.Stop Call MsgBox(Err.Description + vbCrLf + Err.Source) End Sub The error code which i wrote it...

Yes, because in the help it says that it is in VB 6.0.

Hello, I have the following lines in a sample code, which should be correct: Handler: Call Runner.Stop Call MsgBox(Err.Description + vbCrLf + Err.Source) But i got the following error code: Object variable or with block variable not set, on the first line (call runner.stop) I got the same...

And how could i insert the sheet only if it not exist? Thank you. Kenguru

Hello, I have an excel file with 7 sheets. I would like to write a code for creating a sheet at the end of the file (number 8). I wrote the following: Dim xlSheet As Excel.Worksheet Set xlSheet = Worksheets.Add(,"Service") xlSheet.Name = "My Sheet" I wrote Service, because the 7th sheet name...

Thank You! That was what i was looking for (Fromat/Sheet/Unhide). Kenguru

Hello, I have an excel file. I can see the sheet1, but no the sheet2. And I know that it is there. HOw could i see it? Thank you, Kenguru

But I'm not deleting rows, i'm inserting rows. Kenguru

I know that they change location. The problem is that sometimes they are shifted done sometimes not. The nearby code is: a = ThisWorkbook.Sheets(sheet).Cells(ii, 1) b = ThisWorkbook.Sheets(sheet).Cells(ii, 2) c = ThisWorkbook.Sheets(sheet).Cells(i, 16) d = ThisWorkbook.Sheets(sheet).Cells(i...

No I'm doing it from the top. Kenguru.