sps

Is there a trick to get around the 255 R1C1 character limit? I am trying to convert a formula to an array but get a run-time error '13' type mismatch error. I then tried to use named ranges to breakup the formula into pieces which shortened the formula...it worked, but it took WAY too long...

Hi there. I am trying to prepare a macro with two For...if functions and it keeps telling me that the copy and paste area are not the same size when they are. IS there coding to get around this: Sub ISS_vs_SPS() 'Set variables Dim ISS As Worksheet Set ISS =...

I have search previous threads and have tried different coding to delete the entire row of data if the value in column M (12) is zero to no avail. Getting very frustrated as this should be pretty simple coding. I must have a syntax error somewhere as it will only delete one row at a time when...

Our IT department just migrated all of our data to a SPS and then I have a mapped local drive that references that location. Every Client Wkbk I open has a user authentication dialogue that's called on opening the workbook. Every time I go to open a Wkbk, I get a run time error. At first I...