Unsolved
This post is more than 5 years old
13 Posts
0
4437
May 21st, 2008 07:00
deleting same cell's in multiple excel files
Hi
I'm in need of deleting the top 2 cells in every excel file i've created. Basically i have my old company logo on the top 2 cells and it had multiplied across every excel file i've created.
Is there a way for me to delete the same 2 cells across multiple files without opening them all up and pressing delete. I have 200-300 or so files and they are all around 300KB so its taking a very long time to do. I've spent the past 2 hours and done 20 files so far.
can anyone help?
0 events found
No Events found!
abach
1.7K Posts
0
May 21st, 2008 12:00
Short of writing some VBA code, you'll have to manually delete the logo.
Are the files all in the same folder?
Is the logo the only picture in the worksheet?
Is there only one worksheet in each workbook that contains the logo?
The above are the questions needing answers to write code.