I am attempting to create a scatter plot with multiple series from the following table that extends to row 278:

I currently have an excel file that has data in either column E, or F, or both. The data set changes in length, so there might be 3 rows of data or 3000 rows of data. I have figured out how to select all the cells that should contain data.

I am looking for a code that will circle through all worksheets and set the font of all cells to black color. Moreover it should remove all textboxes inside and i would be pleased if it could replace them by a new box.

I want to check if a particular cell has a shape, eg. B7.
if it doesnt exist, make new shape at B7 (B7.top, B7.left).
if it exists, move X columns to the right and make new shape

I have written a VBA code in order to open a number of input files, copy their contents and paste them in other output files on specific sheets.

I’m learning macros as I go, so I hope there is an obvious solution here. Google and Youtube doesn’t seem to help much!
I refer to a specific cell to be changed in a variety of functions, based on the users needs. Inside of each individual function, I have been using ‘Dim’ and ‘Set’ i.e.:

I am making a flow chart, where I want to group the entire flow chart for the user to move it around later if he/she wants.

I am trying to write a VBA macro to highlight the cell (in a range) which has same cell value in column A. I tried the code below, but it highlights all cell in columnA. I am stuck how to validate it against row and range. Any help would be appreciated.

I have tried the below code to open pdf file in Adobe Acrobat Pro. It opens the file dialogue and allows me to select the pdf file. Once i select the pdf file it gives error ” THERE WAS AN ERROR OPENING THIS DOCUMENT. THE FILE CANNOT BE FOUND.” Any help would be great.

THIS DATA IS BASICALLY IDENTIFYING CORRECT CHOICES (A, B, C D)