Error When Pasting Equation from Notepad into Excel Using Recorded Macro

[mjdalmalti]

I'm encountering an issue while recording a macro in Excel for a repetitive task. During the task, I copy an equation from Notepad and paste it into Excel. However, when I attempt to apply this macro to the next day's sheet, I encounter this error

The second problem is when i do "auto fill" for the equation , let's say this day we have 50 rows and tomorrow there will be 90 rows .. when i apply the macro i found the it only made auto fill for 50 rows ?

How can I resolve this issue?

 

[Joe4]

It would be extremely beneficial if you could post your VBA code for us to see!
Please use code tags when posting your code, as noted here: How to Post Your VBA Code

For your auto-fill, the key is to dynamically find the last row of data, and use that variable in your code.

For example, to find the last row with data in column A, you can do this:

Dim lr as Long
lr = Cells(Rows.Count, "A").End(xlUp).Row

You can then reference the range from A2 to the end of column A like this:

Range("A2:A" & lr)

 

[mjdalmalti]

It would be extremely beneficial if you could post your VBA code for us to see!
Please use code tags when posting your code, as noted here: How to Post Your VBA Code

For your auto-fill, the key is to dynamically find the last row of data, and use that variable in your code.

For example, to find the last row with data in column A, you can do this:

Dim lr as Long
lr = Cells(Rows.Count, "A").End(xlUp).Row

You can then reference the range from A2 to the end of column A like this:

Range("A2:A" & lr)

Thank you for your response
I dont use VBA , i am still a beginner at Excel so I use record macro without entering VBA details, or do you mean i had to enter this code inside VBA ?

 

[Joe4]

In Excel. "macros" and "VBA" are really the same thing.
If you use the Macro Recorder, you are just letting Excel create the VBA, but trust me, what you are creating is actually VBA.

Please post the code the Macro Recorder created that you are using.

Note that while the Macro Recorder is a great tool to get snippets of code, it is quite literal, and often needs cleaning-up/editing in order to make it more dynamic.
So it is a great starting point, but often requires edits.