Recent content by DonyBoy

Thanks HarleyQuinn.

I have a folder that has 100s of subfolders. I want a list of all the folder names exported to a Excel column. so, my input should be the main folder path. My output should be the list of all the folder names written to a spreadsheet from Cell A1 downwords. any help will be appreciated

Please explain

I have 2 tables for a library. Table1: has the book details with the book-number being the primary key Table2: has the details of borrowed books. This table also has the column book-number- linked to Table1, using the same column. I need to make an SQL query that gives the list of AVAILABLE...

I don't even know how to 'open' a text file within Excel. I have used some VBA, but it's all within 1 excel sheet. The idea of opening an external file is beyond my knowledge.

I have a folder full of text files. Each of these file has a phrase that needs replacing by another phrase (same phrase for each file).It will take me ages to open each of these text files and do a replace function. Is there a way to create an excel file with macro set up such that 1) in Column...

I need an acurate way of reading off an intersection point from a chart (intersection between 2 curves). Is there way of reading off the X and Y co-ordinates of the intersection as you hover the curser over the intersection point. (it is impossible to solve the 2 equations analytically)Has...

I need an acurate way of reading off an intersection point from a chart (intersection between 2 curves). Is there way of reading off the X and Y co-ordinates of the intersection as you hover the curser over the intersection point. (it is impossible to solve the 2 equations analytically)Has...

I have an incredibly large text files that take ages to open. All I'm interested in seeing is the first 20 lines of each of these text files. Is there are clever way of seeing the first 20 lines, without having to open the entire file- in VBA?

Thanks very much...that was most helpful..

I’m reading the last row in a sheet called “GANT”, but this function is actually called within worksheet_change event of a DIFFERENT sheet- Sheet2. The cose is counting the last row in Sheet2 and not GANT. Please see the code below. ----------------- Private Sub Worksheet_Change(ByVal Target...

actually the above method does give incorrect answers soemtimes. I'm not blamming your code.. most probably i'm doing somethign stupid...soem help will be appreciated...

sorry, i was being stupid... it's just mRow isn't it..sorry again

thanks. i tried using this code that I found in the FAQ section Sub FindLastCell() Dim lRow As Long, lCol As Integer, mRow As Long, mCol As Integer lCol = ActiveSheet.UsedRange.Columns.Count mRow = 0 For i = 1 To lCol lRow = Range(Cells(Rows.Count, i), Cells(Rows.Count, i)).End(xlUp).Row...

is there a way to find the last cell in, say, Column B. The thing is, column B has some empty cells here and there. I want to be able to extract the row-index (eg, 17th row) that has no data whatsoever below it