Search results for query: *

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

I have an excel file that has some macros here and there. Pretty basic macros. Worksheet_change() event etc. I'm encountering a problem when I try to save and open the file again. It totally ruins the file. It says error occured, but Excel made the following repairs. Then below it says damage...

Thanks Geoff, but is there a clever way around this? Basically I have some names in column-B. When a user changes the font colour for a name, I want to colour some cells in that SAME ROW by the same colour of that font. for example, if the user changes the colour font in cell B8 to blue, I...

I’m looking to activate some VB code when the user changes the font colour in a cell. Worksheet_Change doesn’t seem to work. Any ideas?

Also, I forgot to say that cells D5:F5 (or the corresponding row) should be coloured, only if these cells have values 1, 2 or 3 in them.

Hello there, I’m trying to colour some excel cells in a unique way. In column A, I have some names of people. Each person has a unique colour associated with his/her name. So, when I write that persons name in (lets say, cell A5) I want D5:F5 (3 cells) to go blue (or whatever the colour...