I am a newbee to VBA and am creating a project for myself. I have been able to do a lot of work but have got stuck on a few points. Any help would be appreciated.
I have an excel sheet where i write down receipes. I have tried to create a macro wherein i want to save the receipe in a few different formats using a userbox.
Currently my Range on the excel sheet is A1:B60 but i want to make it a dynamic one with maximum of 2 blank rows in between the 2 Headings of Title, Ingreadents and Method.
Issue 1
I have created a macro for save as text but it saves the complete Excel file as text. I need to just save the sheet and not the complete file as txt.
Issue 2
I have created a macro for save as xml but again it saves the complete Excel file as xml. I need to just save the sheet and not the complete file as xml.
Bookmarks