Anyone can help me with my Excel Macro?

Asked By isabela 10 points N/A Posted on - 11/01/2011

I need to reference a cell in a worksheet from within an Excel Macro. I am using the following formula: lcFileNameDataGL = Admin!B9 but won’t work well inside the Macro. I can edit this in Macro but somebody else who is not knowledgeable in Macro will use the file so the revisions must be done in the worksheet and not in the Macro.

• Status: Open
• Question Views: 915
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By jamesstave 0 points N/A #99097

Anyone can help me with my Excel Macro?

 

Macro programming is difficult to create without haven’t sufficient knowledge and attention which was confused. Sometimes in a spreadsheet a cell will contain both numeric characters. You can test your own applications or when you want to treat particular condition as being equivalent to these errors.

Microsoft provides components for common user interfaces. However, you still have to do some of the work in selection the options that will be available on the dialogs and interpreting what to do with user’s selection.

These common u set interface dialogs work exactly the same as in any Microsoft application, but by manipulating the properties, you can use the values they produce in your code. In the development tab select run a macro, in the macro name box click the macro you want to run.

About jamesstave

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/11/2011
• Question Category: MS Excel