Re: $$Excel-Macros$$ Issue with Selection as collection

Wow... I have just done a testing.. and surprising result.. I created a new workbook and created a module.. Then ran the same code it works.. It's something about the that workbook... I think some setting attached to the workbook is causing the issue.. Anyone has any idea?? I keep getting

Re: $$Excel-Macros$$ Issue with Selection as collection

Dear markkim, you forgot to write rcell after next Sub selection_area() Dim rcell As Range For Each rcell In Selection rcell.Value = 1 Next rcell End Sub Thanks and Regards Akhilesh Airen -- -- Some important links

Re: $$Excel-Macros$$ Issue with Selection as collection

Dear Markkim, your code is correct, but please use it within procedure like... Sub selection_area() Dim rcell As Range For Each rcell In Selection rcell.Value = 1 Next End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http