AutoFill a cell with a value

  • Thread starter Thread starter N1KO
  • Start date Start date
N

N1KO

Hi,

I need to automatically fill a cell with a value from another cell once the
other cell is selected.

I have a list of numbers in column F and I need cell H2 to equal which ever
cell is selected or even double clicked (if that's possible).

Is there any way of doing this?

Thanks in advance
 
Install this event macro:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Target.Column = 6 Then Range("H2") = Target
End Sub

Regards,
Stefi

„N1KO†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with this formula 3
Autofill column values in formulas 4
Excel VBA 1
Autofill a row from sheet 1 to a column on sheet 2 1
Autofill to Last Row but Miss Some Rows? 1
AutoFill double click does not work in Excel 2007 3
filter and autofill series number 1
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top