change macro to delete values in rows

Hello everyone,
This macro is used to elimiare values of a selected row from column B to H
leaving unchanged the values in column A.

Please Login or Register  to view this content.

Chiedo un aiuto per una modifica.

Selezionare più di una riga

spero di essere stato comprensibile.
Grazie,
max_max


I ask help for a change.

Select more than one row

I hope I was understood.
thanks,
max_max

you can use

Please Login or Register  to view this content.

or use your last desire row

Thanks Kamboj of fast response.
Your solution is o.k.
But if you must remove 2 or 30 rows as you do?
max_max
-----------------------------------------------------
Grazie kamboj della veloce risposta.
La tua soluzione è o.k.
Ma se deve eliminare 2 oppure 30 righe come si fa?
max_max

Sir I cann't understand how many rows you want to clear if your last row number is definite then you use that with + or if you want to get last row number then you can use - Cells(Rows.Count, "B").End(xlUp).Row with a variable and use that variable at the last like this

Please Login or Register  to view this content.

It is not correct.
Selecting a row deletes all rows
max_max

Sir can you upload the file with example what is your requirement.

Modified
Modificato

cancella più di 1 riga_new.xls

sir here is code

Please Login or Register  to view this content.

No it is still wrong,
the macro should only delete the selected rows
--------------------------------------------------
No è ancora sbagliato.
La macro deve eliminare solo le righe selezionate

Sir, I think this is the result you need.

No it is still wrong,
the macro should only delete the selected rows
-----------------------------------------------------------------------------------------
No è ancora sbagliato.
La macro deve eliminare solo le righe selezionate

No it is still wrong,
the macro should only delete the selected rows
It is written in the sample file Answer # 8
-----------------------------------------------------------------------------------------
No è ancora sbagliato.
La macro deve eliminare solo le righe selezionate
è scritto nella rispota #8

No it is still wrong,
the macro should only delete the selected rows
It is written in the sample file Answer # 8
-----------------------------------------------------------------------------------------
No è ancora sbagliato.
La macro deve eliminare solo le righe selezionate
è scritto nel file di esempio nella risposta #8

Sir you only want to delete data of row no. 3 only or what are selected.

Unfortunately, not knowing English well is difficult to explain.
The macro must delete the data of the rows that are selected with the mouse.
If rows are selected 3/4/5 the macro should only delete these rows,
not the subsequent rows.
----------------------------------------------------------------------------------
Putroppo non conoscendo bene l'inglese è difficile spiegarmi.
La macro deve eliminare i dati delle righe che vengono selezionate con il mouse.
Se vengono selezionate le righe 3/4/5 la macro deve eliminare solo queste righe,
non le righe successive.

Sir, This is your requirement:-

Please Login or Register  to view this content.

Sir in previous coding we select col a not row but in the above coding we select rows. Some misunderstanding.
Hope this will be right.

Thanks Kamboj now works well.
Thanks also to trebor76 also your macro works.
max_max
--------------------------------------------------------
Grazie kamboj ora funziona bene.
Un grazie anche a trebor76 anche la tua macro funziona.
max_max

For Kamboj.
Hello Kamboj your macro works well almost.

Please Login or Register  to view this content.

If I select for example the rows starting from 5/6/7/8 deletes all rows,
if I select the rows starting from 8/7/6/5 deletes only the row 8.
Can be corrected?
I hope I explained.
max_max

----------------------------------------------------------------------------

Per kamboj.
Ciao Kamboj la tua macro funziona quasi bene.
Se seleziono per esempio le righe partendo da 5/6/7/8 elimina tutte le righe,
se seleziono le righe patendo da 8/7/6/5 elimina solo la riga 8.
E' possibile correggere?
Spero di essermi spiegato.
max_max

Sir
just change this line in macro

Please Login or Register  to view this content.

actually it gets activecell row number which is 8 when you select from below to up line so it clear only that row basically we need selection rows numbers whatsever it is select from above to down or below to up.

Thanks Kamboj now is ok.
max_max