How to refer "user's define reference" in a macro?

**dusit_t** · 04-09-2012, 11:24 AM

Hi,
I have a few questions regarding inputting user's defined reference in macro. Let me explain with the following code sample (my problems are listed in 1-3 of below sample).

Please Login or Register  to view this content.

Please help fixing above 1-3 codes with proper ones.

**GeneralDisarray** · 04-09-2012, 11:37 AM

I would suggest you find the last row using the following trick (instead of prompting the user). This example would find the last row with data in the A column.

LastRow = activesheet.cells(rows.count,1).end(xlup).row

What is it you are trying to do exactly, you may be needing to recode this entirely, code you provide an example sheet?

**dusit_t** · 04-09-2012, 02:18 PM

Hi GeneralDisarray,

Thank you for your suggestion on auto finding "LastRow".

What I try to do with macro is to reformat a text file report into a worksheet that contains formula in predefined format.
The real worksheet has more complicate data; therefore, I created another sample worksheet with some descriptions about my requirement. As I'm not very keen on macro, I have not yet added the routine to this sample sheet. Anyway, I think this info. would help you understanding my needs.

Dusit