VBA Code User Range Selection
I have a current VBA and I would like to extend it to do the following after
the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . -- hopalong |
VBA Code User Range Selection
Hi,
Try this, when the input box pops up simply drag to select a range Set deleterange = Application.InputBox(prompt:="Select a range of cells", Type:=8) Mike "jimbo" wrote: I have a current VBA and I would like to extend it to do the following after the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . -- hopalong |
VBA Code User Range Selection
Mike hi thanks for replying. Your suggestion works fine up to displaying a
message box and allows the user to select the range. However if the user selects OK in the message box is does not delete the selected range. Can you help further? Many thanks -- hopalong "Mike H" wrote: Hi, Try this, when the input box pops up simply drag to select a range Set deleterange = Application.InputBox(prompt:="Select a range of cells", Type:=8) Mike "jimbo" wrote: I have a current VBA and I would like to extend it to do the following after the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . -- hopalong |
VBA Code User Range Selection
Hi,
Like this Set DeleteRange = Application.InputBox(prompt:="Select a range of cells", Type:=8) DeleteRange.ClearContents Mike "jimbo" wrote: Mike hi thanks for replying. Your suggestion works fine up to displaying a message box and allows the user to select the range. However if the user selects OK in the message box is does not delete the selected range. Can you help further? Many thanks -- hopalong "Mike H" wrote: Hi, Try this, when the input box pops up simply drag to select a range Set deleterange = Application.InputBox(prompt:="Select a range of cells", Type:=8) Mike "jimbo" wrote: I have a current VBA and I would like to extend it to do the following after the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . -- hopalong |
VBA Code User Range Selection
Mike thanks for your support works great.
-- hopalong "Mike H" wrote: Hi, Like this Set DeleteRange = Application.InputBox(prompt:="Select a range of cells", Type:=8) DeleteRange.ClearContents Mike "jimbo" wrote: Mike hi thanks for replying. Your suggestion works fine up to displaying a message box and allows the user to select the range. However if the user selects OK in the message box is does not delete the selected range. Can you help further? Many thanks -- hopalong "Mike H" wrote: Hi, Try this, when the input box pops up simply drag to select a range Set deleterange = Application.InputBox(prompt:="Select a range of cells", Type:=8) Mike "jimbo" wrote: I have a current VBA and I would like to extend it to do the following after the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . -- hopalong |
VBA Code User Range Selection
range for deletion Be careful when using the word "delete". Strictly speaking, it means to remove the range from the worksheet and shifting the appropriate rows and columns upwards and to the left. If you merely want to remove the content of the cells, use the term "clear". Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Mon, 4 Jan 2010 02:45:01 -0800, jimbo wrote: I have a current VBA and I would like to extend it to do the following after the last command:- allow a user to select a un pretermined range for deletion (could be any number of coumns and rows) and for the macro to delete that range and either restart the macro to continue with it's next command or alternatively to stop via perhaps a message box instruction for the user . |
All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com