Hardcoding certain cells

[Harkahl]

Okay I am assigned to copy worksheets (which have info about financials according to different location) into a new workbook and hardcode tables in the worksheet, change name of a row, and delete some columns. I have to repeat this process manually for all different locations ( there are like 60 of them) so I was wondering if there’s a way to use macro in this situation.

To summarize, I want a macro that can:

• Hardcode specific cells
• Change name of a row
• Delete some columns.

 

[BSALV]

most of those actions, you can record with the macro-recorder and afterwards copy and change.

hardcode specific cells :

With sheets("MySheet").range("B20:D100")
.value=.value
end with

Change name of a row ???

sheets("MySheet").rows(25).name="My_Row25"

Delete some columns

sheets("MySheet").columns("X").delete

 

[Harkahl]

most of those actions, you can record with the macro-recorder and afterwards copy and change.

hardcode specific cells :

With sheets("MySheet").range("B20:D100")
.value=.value
end with

Change name of a row ???

sheets("MySheet").rows(25).name="My_Row25"

Delete some columns

sheets("MySheet").columns("X").delete

Yes! Thank you, I was able to just record the macro. It was a lot simpler too!!

 

[BSALV]

you're welcome