Search results

Hi Narayan Many thanks for your investigative work. Is there any way that I can change the isformula function as I need this to color all cells that have a formula in it? Or is there a better way to color all cells that have a formula in it? I presume that this function uses too much memory...

Hi Narayan, here's my file. The macro that causes the problem is called InsertCol Many thanks in advance for looking into this

Hi Hui and Narayan, I greatly appreciate your help Looking at below code Sub InsertCol() Dim oSh As Worksheet Dim oLc As ListColumn Set oSh = ActiveSheet Set oLc = oSh.ListObjects("Table3").ListColumns.Add(30) oLc.Name = InputBox("Enter the month and year for the header of this new...

Hi Hui, I copied the big table on to a new sheet but with fewer rows. Amazingly the code now works. However that also proves to me that the problem is not that the field or header already exists or that table 1 doesn't exist. The weird thing really is that when I step into the code the...

Hi Can somebody please help and explain why below code works on a small table (excel 2010) but not on a big table? Sub insCol() Dim oSh As Worksheet Dim oLc As ListColumn Set oSh = ActiveSheet oSh.ListObjects("Table1").ListColumns(3).Range.Select Set oLc =...

Hi, I want to make sure that in cell K2 (part of an Excel 2010 database column, called "Accepted") only dates can be entered or the words "Declined" or "Withdrawn" I set up a Function in VBA called "idate" which returns true if the parametercell referenced is a date. My validation formula is...

Hi The condition is as before and the column being filtered for the condition is column B. If the condition is met we put the word "Stock" in column G. If the condition is not met, I would like to copy the value of column F (as offset) in to column G I was wondering if we could use another...

Hi Smallman I must admit your code is actually very smart, and I am warming up to it. May I ask your advice for an other challenge? please note attached data snippet How would I go about using the auto filter solution to put in the offset the value of column F when the condition of the...

Marvelous! Yes, it did! How one wrong bracket can make a difference ...Much appreciated indeed! Cricketnz

Hi Smallman, Many thanks for your reply, however I need more control hence the idea of selecting small ranges of the spreadsheet. Cricketnz

Hi Roe3p Your comments made a lot of sense, so I was quick to try it out. Unfortunately, it is still not doing anything. If you'd like I'm happy to upload a file

Hi, Can anybody tell me why below code does NOT put the formula or its result in the selected cells? I can not see what I'm missing here, but I'm certainly are missing something. What I want to do is based on the presence of a search string in a selected range of cells (all in the same column)...

Hi Narayan Many thanks for this! Much appreciated. The main thing for me is that it won't throw an error, and that goal has now been achieved. Best regards, Jim

Thanks, Narayank! That certainly explained it. I changed the formulas to values, but I still get the same error. http://www73.zippyshare.com/v/66513756/file.html The code does now total all required columns Is there a way I can get rid of the error message? Many thanks in advance

Hi Narayank. I've tried the code under the P.S. but it gives me a runtime error "1004" "no cells were found" and doesn't subtotal the last required column. I added a new worksheet here and changed the initial MyColumn to "E" here's the link to that workbook...

No reply, but an addition to above question I've got this code below : Sub SumBetweenBlanks() Dim Area As Range, MyColumn As String MyColumn = "A" For Each Area In Columns(MyColumn).SpecialCells(xlConstants, xlNumbers).Areas SumAddr = Area.Address(False, False)...

Hi, I need some help with vba I've got this exported sales report http://www8.zippyshare.com/v/5789217/file.html It doesn't have totals for the quantities. I would like to use some vba code to add the totals for the quanties on each subtotal line However I do not know how many months...