Hi Rajender, Use the following VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rg As String MsgBox Target.Address & " has been selected" 'displaying the selected cell address rg = Split(ActiveCell.Address, "$")(1) & 5 'getting the column name and createing the range column name and 5 to pick up the value from the row 5 Target.Value = Range(rg).Value End Sub NOTE: Please paste the above code in a sheet object and not a module. This will work only for the sheet where you have pasted the value. You can remove line # 3 from the code if you don't need to display the address of the selected cell. Please let me know if you have any further query regarding this. Regards, Andy On Mon, Jul 5, 2010 at 2:43 PM, Rajender Soni <soni.rajen...@gmail.com>wrote: > Hi > > Pls revert to the issue below: > > My rown no. is fixed - 5, column no. is changing, now i want that suppose i > click in column g, then i will get the cell value of G5, if i click on > column a, anywhere in column a will get the cell value of cell a5. > > Regards > Rajender Soni > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe