Sub copysheet()
Dim lastLine As Long
Dim findWhat As String
Dim toCopy As Boolean
Dim cell As Range
Dim i As Long
Dim j As Long
Dim newbook As Workbook
'Application.ScreenUpdating = False
findWhat = CStr(InputBox("Enter the AREA name to search for: "))
lastLine =...
The above codes, don't stop from getting triggered.
i need to set up a flag so that while the workbook is refreshing, no change should be triggered in THIS SHEET.
I have a code in a sheet which works only when anything in COLUMN 11 changes.
Range is ("X2:X2000") ---> column X will have the USER's name.
And this happens when something in column K is changed. (.offset(0,13) ------> offset from column K, is column X )
// What are you referring to by...
Hi everyone,
I have just recently started and also I am learning on my own, the VBA code for Macros in Excel.
I just thought, I'll get my problem solved if and only if I share it with scholars over here. [pc3]
I have a code within a sheet which generates Username when activecell is target...
