A macro to change the values on a specified cell
Closed
prov
-
25 Aug 2015 à 07:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Moderator Last seen 27 December 2022 - 27 Aug 2015 à 11:32
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Moderator Last seen 27 December 2022 - 27 Aug 2015 à 11:32
Related:
- A macro to change the values on a specified cell
- Change computer name cmd - Guide
- How to change free fire facebook account to google account - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Change lg tv name - Guide
- How to change time on whatsapp - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Moderator
Last seen
27 December 2022
555
27 Aug 2015 à 11:32
27 Aug 2015 à 11:32
Hi Kaan,
How about this code:
Note 1: Since your result is 'Sheet1'$G$5, I assumed your formula should have been A:A instead of G:G.
Note 2: Your destination sheet is called "Sheet1", but you didn't mention the source sheet name. I took the liberty to call it "Master".
Best regards,
Trowa
How about this code:
Sub RunMe() Dim MyValue As String Dim cFind As Range MyValue = Sheets("Master").Range("N7").Value Sheets("Sheet1").Select Set cFind = Columns("A:A").Find(MyValue) If cFind Is Nothing Then MsgBox "Value not found." Exit Sub End If cFind.Offset(0, 6).Value = MyValue End Sub
Note 1: Since your result is 'Sheet1'$G$5, I assumed your formula should have been A:A instead of G:G.
Note 2: Your destination sheet is called "Sheet1", but you didn't mention the source sheet name. I took the liberty to call it "Master".
Best regards,
Trowa