Hi!
Hope someone can help. I'm sure this is probably very easy for someone. :-)

I have a workbook and 1 tab is called OEM material with about 1000 items
listed and sorted by categories and another tab called Template.

I have created 11 macros that will select certain data by category from the
OEM material tab and insert it in a selected area on the Template tab. The
different categories of data selected are all different sizes but pasted in
the same starting point (ex. cell B1). If I click on macro "A" I get my list
of items from the OEM material tab. When I click on macro "B" I get my
correct list of items from the OEM material tab HOWEVER, the list is smaller
than macro "A" data, and when macro "B" is ran, data from B pastes onto A
but some of the data from A is still visible.
So, how do I have the macro delete the current macro data before running
(pasting) the next selection of data?

Thanks!
KS

Hi,

Insert a command like this at the start of your macro with the range
suitably changed

Columns("B:G").ClearContents

Mike

"KS-Macro" wrote:

Hi!
Hope someone can help. I'm sure this is probably very easy for someone. :-)

I have a workbook and 1 tab is called OEM material with about 1000 items
listed and sorted by categories and another tab called Template.

I have created 11 macros that will select certain data by category from the
OEM material tab and insert it in a selected area on the Template tab. The
different categories of data selected are all different sizes but pasted in
the same starting point (ex. cell B1). If I click on macro "A" I get my list
of items from the OEM material tab. When I click on macro "B" I get my
correct list of items from the OEM material tab HOWEVER, the list is smaller
than macro "A" data, and when macro "B" is ran, data from B pastes onto A
but some of the data from A is still visible.
So, how do I have the macro delete the current macro data before running
(pasting) the next selection of data?

Thanks!
KS

If you are using column B in the Template sheet to store the results of the
macros, then put this snippet at the beginning of macro "B"/

'Sub header and Dim statements here
Dim lstRw As Long
lstRw = Sheets("Template").Cells(Rows.Count, 2).End(xlUp).Row
Sheets("Template").Range("B1:B" & lstRw).ClearContents
'The rest of your code here
End Sub

Change the sheet name if required.


"KS-Macro" wrote in message
...
Hi!
Hope someone can help. I'm sure this is probably very easy for someone.
:-)

I have a workbook and 1 tab is called OEM material with about 1000 items
listed and sorted by categories and another tab called Template.

I have created 11 macros that will select certain data by category from
the
OEM material tab and insert it in a selected area on the Template tab. The
different categories of data selected are all different sizes but pasted
in
the same starting point (ex. cell B1). If I click on macro "A" I get my
list
of items from the OEM material tab. When I click on macro "B" I get my
correct list of items from the OEM material tab HOWEVER, the list is
smaller
than macro "A" data, and when macro "B" is ran, data from B pastes onto A
but some of the data from A is still visible.
So, how do I have the macro delete the current macro data before running
(pasting) the next selection of data?

Thanks!
KS

WOW! Such an easy solution! Thanks. I feel stupid for asking but I am new at
these.

Thanks so much for your help!!

"Mike H" wrote:

Hi,

Insert a command like this at the start of your macro with the range
suitably changed

Columns("B:G").ClearContents

Mike

"KS-Macro" wrote:

Hi!
Hope someone can help. I'm sure this is probably very easy for someone. :-)

I have a workbook and 1 tab is called OEM material with about 1000 items
listed and sorted by categories and another tab called Template.

I have created 11 macros that will select certain data by category from the
OEM material tab and insert it in a selected area on the Template tab. The
different categories of data selected are all different sizes but pasted in
the same starting point (ex. cell B1). If I click on macro "A" I get my list
of items from the OEM material tab. When I click on macro "B" I get my
correct list of items from the OEM material tab HOWEVER, the list is smaller
than macro "A" data, and when macro "B" is ran, data from B pastes onto A
but some of the data from A is still visible.
So, how do I have the macro delete the current macro data before running
(pasting) the next selection of data?

Thanks!
KS

Glad I could help. The learning curve is very steep when you start!!

"KS-Macro" wrote:

WOW! Such an easy solution! Thanks. I feel stupid for asking but I am new at
these.

Thanks so much for your help!!

"Mike H" wrote:

Hi,

Insert a command like this at the start of your macro with the range
suitably changed

Columns("B:G").ClearContents

Mike

"KS-Macro" wrote:

Hi!
Hope someone can help. I'm sure this is probably very easy for someone. :-)

I have a workbook and 1 tab is called OEM material with about 1000 items
listed and sorted by categories and another tab called Template.

I have created 11 macros that will select certain data by category from the
OEM material tab and insert it in a selected area on the Template tab. The
different categories of data selected are all different sizes but pasted in
the same starting point (ex. cell B1). If I click on macro "A" I get my list
of items from the OEM material tab. When I click on macro "B" I get my
correct list of items from the OEM material tab HOWEVER, the list is smaller
than macro "A" data, and when macro "B" is ran, data from B pastes onto A
but some of the data from A is still visible.
So, how do I have the macro delete the current macro data before running
(pasting) the next selection of data?

Thanks!
KS