I have this code but the problem is I don't understand what they mean by 'duplicate declaration in current scope and how to fix it
Code:
Sheets("tran1").Select
Rows("2:2").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Dim dentry As Long
Range("tran1!a2").Value = Range("sheet1!a11").Value
Range("Tran1!b2").Value = Now
Worksheets(2).Rows(x).Select
Dim x As Integer
x = 0
Do
x = x + 1
Loop Until Range("sheet1!a" & x).Value = Range("sheet1!a11").Value
Range("sheet1!c & x").Value = Range("sheet1!c & x").Value + TextBox2d.Value
Range("Tran1!D2") = TextBox2d.Value
Range("tran1!c2") = Range("sheet1! c & x").Value
Last edited by a moderator: