excel & vba 2011 mac

Hello! I have been working on this issue all day, so I am hoping someone here is able to help. I am trying to create a VBA script that will allow me to easily complete a copy > paste special (transpose) operation. 1. I need to select a custom range of data 2. Loop through the data by row 2.1...

I need to write a script to save a worksheet with to a predetermined location and the save name is filled from values within the worksheet. I can get it to save in the proper location, but the file name returns a combination of FATPMetiFolderPath and FATPMetiPath...

Hi, First I must admit that i'm not so good at Ms.Excel (specially with macros). So i dunno whether my problem is a piece of cake or it's totally impossible. So pls have a look and help me. Currently I'm making a attendance sheet. I must have following abilities in that sheet. Situation If...

I have a large number of data sets, and my code goes through each and runs solver on each. The macro works flawlessly on Excel for Windows. Upon looking into this problem it is a known one, yet there aren't any solid solutions to bypass/fix this issue. What happens is the VBA macro runs...

I have had been writing 28 different macros into my Personal Macro Workbook on Excel. Mac 2011 version. Today, I opened the file and redid a macro and saved it. Came back to record it again with other changes and every time I do, the system creates a New Personal Macro Workbook and saves it...

Excel for Mac 2011 I need to extract a number from within a cell of text. The number is not located in the same place and there could be other numbers within the cell. I have to go cell-by-cell to visually key these numbers in. There are thousands of rows. Any help would be appreciated. Cell...

Application/Platform: Excel 2011 for Mac I have an Excel spreadsheet with thousands of rows of data that I need to sort in descending year order. I am very new to this level of Excel manipulation. The problem is the current values can be a range of abbreviated years, a single year or all years...

Hi, I am entirely new to Excel and coding in general. I have began to start playing around with it in the simplest form but have the desire to start learning. I am in dire need of something to help speed up a task that I must do daily at work. I am working on two Excel Workbooks: one is a...

Hi everyone, I am still a big newbie when it comes to writting in vba. I still make a lot of mistakes, but it is getting better with the practice, and the help i got online and from some buddies. Anyway, I have a folder containing 5 workbook (5 CAC40 stocks), each containing between 2 and 3...

Hello! I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing. No problems with recording separate macros with relative or absolute reference. Problems description: I have few sheets with tables of the same...