Search results for query: *

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 =...

IS THERE A POSSIBILITY OF CREATING A MACRO INSTEAD OF AN EVENT IN THE SHEET????????

It's already done. But still, I am not able to stop the SHEET macro from triggering. :'(

MAINLY I HAVE TO DISABLE THIS PRIVATE MACRO WHILE THE OTHER MACRO IS RUNNING. IS IT POSSIBLE...?????????//

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...