Excel VBA input data to next empty Range
Closed
Niroth
Posts
1
Registration date
Thursday 30 April 2015
Status
Member
Last seen
30 April 2015
-
30 Apr 2015 à 21:47
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Moderator Last seen 3 July 2015 - 1 May 2015 à 08:09
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Moderator Last seen 3 July 2015 - 1 May 2015 à 08:09
Related:
- Excel VBA input data to next empty Range
- How to copy data from one excel sheet to another - Guide
- Excel vba range find - Guide
- Vba excel mac - Guide
- Excel move data from one sheet to another - Guide
- Excel vba timer - Guide
1 response
MaxStart
Posts
338
Registration date
Tuesday 3 March 2015
Status
Moderator
Last seen
3 July 2015
69
1 May 2015 à 08:09
1 May 2015 à 08:09
Sub FETCH_Data()
Dim x As Variant
x = InputBox("Enter the Code :")
If x <> "" Then
If Range("J6").Value <> "" Then
Range("J7").Value = x
Else
Range("J6").Value = x
End If
End If
End Sub
