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 January 16, 2023 - Aug 27, 2015 at 11:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 27, 2015 at 11:32 AM
Related:
- A macro to change the values on a specified cell
- Run macro when cell value changes - Guide
- How to change idm language - Guide
- Change computer name cmd - Guide
- How to change date format in excel - Guide
- Request a birthday change locked account - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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