Edit Clear contents of cells in CommonSheet to sheet name

[RAJESH1960]

Hello JohnnyL,
When I press the first button Generate Master xml. there are 3 rows in Import masters sheet. When I press the second button Generate Purchase xml it deletes all the rows except the first which it doesn't as it is not at all connected to purchase xml. The good thing the master xml has generated 3 rows of data and saved it on the desktop but the question is why is it deleting the data. Is the common sheet code connected to both master and purchase codes? Can you edit the code from deleting the data in the Import Master sheet.?

Sub ClearCommonDataFromSheet(CommonSheet As Worksheet)
'
    Dim LastRowInCommonSheet        As Long
    Dim LastColumnLetterCommonSheet As String
'
    With CommonSheet
        LastColumnLetterCommonSheet = Split(Cells(1, (.Cells.Find("*", _
            , xlFormulas, , xlByColumns, xlPrevious).Column)).Address, "$")(1)                  ' Get last column letter used in CommonSheet
        LastRowInCommonSheet = .Cells.Find("*", , xlFormulas, , xlByRows, xlPrevious).Row       ' Find last row # used in CommonSheet
        .Range("A3:" & LastColumnLetterCommonSheet & LastRowInCommonSheet + 1).ClearContents    ' Clear contents of cells in CommonSheet
    End With
End Sub

 

[johnnyL]

Sorry, I don't understand the question. Can you rephrase your question?

 

[davesexcel]

Could be just as easy

.range(.cells(3,1),.cells(lastrw,lastcolumn)).clearcontents

 

[RAJESH1960]

Sorry, I don't understand the question. Can you rephrase your question?

if you run the purchase import xml using F8 and keep the import master sheet in view, you will notice that it is deleting all the rows except the first one whereas it has not to do anything with the import master sheet.

 

[RAJESH1960]

Could be just as easy

.range(.cells(3,1),.cells(lastrw,lastcolumn)).clearcontents

I don't want it to delete the data of import master sheet which is included in the common sheet. Common sheets are Import master sheet, purchase data sheet and Import purchase sheet.

 

[johnnyL]

if you run the purchase import xml using F8 and keep the import master sheet in view, you will notice that it is deleting all the rows except the first one whereas it has not to do anything with the import master sheet.

If I recall correctly, that is how you wanted it set up. You wanted all the sheets cleared.

 

[RAJESH1960]

If I recall correctly, that is how you wanted it set up. You wanted all the sheets cleared.

That is when I want to clear the old data and use a new data. When I run the code it will display the number of rows in import masters, purchase data and Import purchase sheets. Not to worry, as I said the xml has captured all the 3 rows before getting deleted. This is actually not an issue, but it shouldn't delete the Import master data when I run the generate purchase xml code. Just curiosity and trying to get it corrected if possible.

 

[johnnyL]

If you don't want it that way now, Look to the 'Sub Pre_XML_Code()' section. That is where it is setup to clear various sheets.

Move the lines of code from there into the individual routines for generating your xml sheets.

 

[RAJESH1960]

Look to the 'Sub Pre_XML_Code()'

I don't know how but I did it right.

 

[johnnyL]

LOL. Great!!!