overcome

I try to set up Const C As String = 2019.2020 , but the will only accept 2019/202 Please advise on how to overcome this

I copied a range of cells and pasted them into anew WB as links. This works fine on my pc but on my co-workers it does not. Seems the drive is mapped as "X" rather than "Z". I can overcome this on a user by user basis but would prefer a bettter solution. Suggestions? Range("B2").Select...

Greetings, I would like to write a conditional loop that upon meeting the condition(s) will produce a set of variable values to be placed in another sheet. I would like to be able to produce variables for all instances when a cell value associated with a row (and the counter variable in the...

Hi guys, for one of my spreadsheets i wanted the vba to check if a cell was blank in the first column of my table, and if so to delete it. this is the code which i usually use Range("IRA[CIO]")..SpecialCells(xlBlanks).EntireRow.Delete but when i run it, i get an error saying delete method of...

HI All, i have the following formula: =HYPERLINK("'"&MTEAM1&"'"&"!", "LIZ T") the formula accepts fine, but does not work the Value of MTEAM1 is "Liz T" and i have a sheet called "Liz T" but when the hyplerlink is clicked it just states cannot fin specified file any ideas on how to...

I've entered this bit of code into a macro and it's working ok: ActiveCell.FormulaR1C1 = "=MID(R[0]C[-2],SEARCH(""Range"",R[0]C[-2])+6,1)" however, when the cell doesn't have the word Range it returns a 'Value' error. To overcome this I added an ISERROR function...

Hey everyone, Here's a spreadsheet I am working on: https://www.dropbox.com/s/xavhulqwi91xamh/Profitability%20Calculator.xlsx?dl=0. My goal is to make a calculator that is streamlined and aesthetically pleasing as I can. Right now, I have set it up to do the calculations for me, but I have hit...

Dears Group Members, I have very long excel (IF) Formula with 292 criteria, a message appear tells me that: (" The specified formula can not be entered because it uses more than 64 levels of nesting"). I ask for your prompt advice/reply in order to overcome the above mentioned error...

Dear all, I am trying to refresh an excel file that is connected to SQL and I am getting the message that a pivot table cannot overlap another pivot table. I had only one PT that derived form the table that is refreshed but I have linked it to another table Nonetheless I still getting the same...

Sometime I open several workbooks and then I cannot select any cells as it appears to be frozen. I then close the workbooks and close Excel and reopen and then I can work on any of the cells I would like to know how to overcome this. I have 16MB of ram and am using office 2016 64 Bit