ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating a macro in excel (https://www.excelbanter.com/excel-worksheet-functions/19312-creating-macro-excel.html)

Not sure what I am doing

Creating a macro in excel
 
Hi, I am new to the whole macro idea. Everyday I create a worksheet that
each column needs to be formatted in a specific way. The only problem is
that there may be a different amount of rows in each file and I have rows
that need to be deleted after certain informational rows. I am not very
familiar with the visual basic editor. I created my macro using the record
and stop functions. It will work fine everytime if I use the exact file but
if I open a new file that has a different number of rows it will not properly
function. Can you help me?

Bob Phillips

Post the code to help us.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Not sure what I am doing" <Not sure what I am
wrote in message
...
Hi, I am new to the whole macro idea. Everyday I create a worksheet that
each column needs to be formatted in a specific way. The only problem is
that there may be a different amount of rows in each file and I have rows
that need to be deleted after certain informational rows. I am not very
familiar with the visual basic editor. I created my macro using the

record
and stop functions. It will work fine everytime if I use the exact file

but
if I open a new file that has a different number of rows it will not

properly
function. Can you help me?





All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com