cols

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

I have two lists of numbers: long lists of about 1000 each in cols Aand B. If I enter a new number into cell D1 and run vba code I should like to output in cells E1 and F1 an entry from each of Cols A and B whose sum equals the new number. If there is more than one possible solution then other...

Earlier I was trying to code a program to count the rows and columns of all the individual sheets of my work book, and then save all of the results into an Array. I have it connected to a button, and sometimes it will just give me 0s as a result when I print the array, and others times I will...

Just a quick question, Since I've been learning arrays I've tried to interject them into places where I can. For example here, I am deleting certain columns based on their column number, pre-set in an array. Dim cols As Variant Dim counter As Double Dim Top As Double cols = Array(8, 5...

Hi All Here, I am having problems with the code listed below, How can I Copy and Paste cell Value only Not the Formula? Thanks Sub CopyPaste2() Dim x, R, C, Cols As Long Dim rngSource As Range Dim wksResult As Worksheet Set rngSource = Sheet1.Range("A1:D90")...

Hello all , I am needing to get a macro that gives me the results I have in cols BJ and BK . I tri I have entered 2 x new dates in col B hilited in yellow . I know horse Magic is xup 5 today col BI . Cell B17 I know horse Tavistock is xup 2 today col BI. Cell B25 Just need to look back for...

Hi I have a worksheet with 60 Columns. Col A contains product groups. Working across the sheet all subsequent cols on row1 have customer name and then running down the col various discounts that customer receives for the different product groups. The cols contain some blanks as not all...

I did a search for compare threads and there are numerous posts but I didn't manage to find one of the more simpler tasks covered - I'm sure they are hiding in there somewhere! If you can point me towards one that meets my needs or if you can suggest a solution via Reply post I'd be very...

In cell A1 I have a date, in cell A2 I have another later date. In column B I have dates and in column C and D I have numbers. I need a function to return the sum of the numbers in cols C and D between the dates specified in cells A1 and A2. Many thanks

<colgroup><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> ################################################################################################################################### Company Adrian Steel Co. CompanyAddress Mailing 906 James St. Adrian MI...