Greetings,
When I record a macro, the excel cells(fields) coded are fixed and not relative. i.e unable to do similar type of operations at different cells. How to solve this problem. Is there any settings to be done.
Thanx.
Greetings,
When I record a macro, the excel cells(fields) coded are fixed and not relative. i.e unable to do similar type of operations at different cells. How to solve this problem. Is there any settings to be done.
Thanx.
View>>Macros>>In the drop down option select Use Relative References
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
This link describes how to record using relative references.
Relative References in Macros
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks