A macro to change the values on a specified cell
Closed
prov
-
Aug 25, 2015 at 07:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 27, 2015 at 11:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 27, 2015 at 11:32 AM
Related:
- A macro to change the values on a specified cell
- Change computer name cmd - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Request a birthday change link - Guide
- How to change free fire facebook account to google account - Guide
- How to change language in kmplayer - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 27, 2015 at 11:32 AM
Aug 27, 2015 at 11:32 AM
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