+ Start a Discussion
Geetha ReddyGeetha Reddy 

Macros in Excel sheet..

HI

Can any one know Macros in Excel sheet.....

 

My Requirement :

 

For example we have n records , in it I want to delete n-1 records and I want to display nth Record...

 

 

Can any one help on this issue ....

Navatar_DbSupNavatar_DbSup

Hi,

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task.

 

  1.  On the Tools menu in Microsoft Excel 2003, point to Macro, and then click Visual Basic Editor.

  2.  On the Insert menu, click Module.

  3.  Type or copy your code into the code window of the module.

  4.  If you want to run the macro from the module window, press F5.

  5.  When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

Geetha ReddyGeetha Reddy

ya i did all the procedure but i am able to delete nth record.

For example :

 

A12

A1

A3

A-9

 

From above example i can delete 

A1

A3

A-9

 

but i want to delete 

 

A12

A1

A3

Now i want to display 

A-9