fix

Hi All, The following code gives a name error in cell I2. Anyone know how I could fix it? StartYear2018 is a named cell. Working with excel 2007 on a PC. Dim StartYear As Double StartYear = Range("StartYear2018") Range("I2").Select ActiveCell.FormulaR1C1 = "=+SUM(R[1]C...

Hi experts! I've searched the old posts regarding this problem but I can't find the right fix. I have multiple worksheets with buttons and they keep resizing after I generated them in PDF forms. I've set the "Don't move or size with cells", placement property to 3 and tried to use this code...

Hi I have a strange problem with one workbook. When you do anything that requires a recalculation of the sheet the graphics are distorted so that sections of other sheets appear overlaid with the current sheet. Clicking on different tab then returning is a short term fix but I'm keen t know of...

I have the following line of code in my macro but it will not work. I keep getting that error message along with "Unable to get the VLookup property of the WorksheetFunction class. After guessing and trying many different ways to fix it, I've given up. Any help would be greatly appreciated...

I have heard about using sum(sumif) but in the examples, they use the value. I want to use the cells. Can someone please fix this formula for me please...

I want to create and print files with the following logic : file 1 : keep row 1 Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart and add row 2 11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US...

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "export!R1C1:R13002C10", Hi Everyone, can anyone pls help me on this.. Columns are fix from A to J. Rows will go change. how do I mention here dynamic range..?

I have this code below to change delimited comma text to specific columns with a command button. It works great. When I want to copy and paste another example in A1, the data is not correct. It seems to be already formatted but in the wrong column. I can't find a way to fix it other...

I have the formula below working but I need it to pull a portion of the text found not the whole string. My fix is from another formula I worked out. but it is throwing an error. Can anyone help me fix this to work? I have bolded what I need it to find for every iteration. It is supposed to...

Hello, I am trying to forecast into the future using excel's automatic forecast function. It's producing negative values, when the minimum possible is 0 (as it's number of items sold). Is there anyway to fix this, or another way to forecast that might be better? Please help!

Hi all, I have an IF statement that is not working and I am after someone with more knowledge than I have to help me fix it, or make another formula to the same effect. My statement is trying to perform some quick stats to identify start progress. The two letter words are the initials of my...

I have a file that launches several userform with images when opened which serves as a reminder to the critical part of the task. I have 5 reminders to be exact and I want it to be visible all the time. I have already managed to fix the close button but my problem now is that user can move the...

I copied a column of data and pasted it in another column, the letters are now red instead of black and it wont let me fix it. Does anyone know what is going on here!?

Hello All, I'm trying to make this cell say nothing if there is no data in column A. In other words, I don't want the cell to say "N/A" or give me an error. The formula doesn't work and I know it's because it doesn't see any data in cell A1498. I just can't seem to figure out to make this...

Could you help me to fix the macro of the attached file to make it work again? Thank you https://www.dropbox.com/s/ltqbn3wg4028qif/google_results.xlsm?dl=0

Hi: I have in sheet named PT balances laid out as: Col C Col D Col E Oct 2017 $1,200.00 Nov 2017 1,000.00 I want to sum data into sheet 2 I8 =SUMPRODUCT(('PT balances'!$C$4:$C$23={"Oct","Nov","Dec"})*('PT balances'!$D$4:$D$23="2017")*'PT...

New to excel, have a formula that doesnt seem to work. Anyone know how to fix? =SUM('Jan 14'!L24+'Jan 28'!L24+'Feb 11'!L24+'Feb 25'!L24+'March 11'!L24+'March 25'!L24+'April 8'!L24+'April 22'!L24+'May 6'!L24+'May 20'!L24+'June 3'!L24+'June 17'!L24+'July 1'!L24+'July 15'!L24+'July 29'!L24+'Aug...

Yesterday, accidentally deleted some of the records in MDB file. Any quick and reliable way to fix it?

"Column 'Serial #' in Table '300 Machines' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table" This error is killing me and I have no idea how to fix it. The dumb thing about it... I...

I've tried printing the active sheet and gridlines don't appear on several rows. I've tried deleting and recreating the rows and it still doesn't work. Does anyone know why it doesn't print and how to fix it? Thanks in advance.