method

Hi, So I have this sheet that gets streaming data from another app. I want to execute some code when the value of some cells change. I tried Worksheet_Change method but it does not detect changes to the values(Im guessing it only detects manual input?) Stole this method from the forum, have no...

Dear Gents, I test the following code and show an error Runtime error 1004 Method 'Range' of object '_worksheet' failed. Would you please help me to figure out why bold codes have range problem? Thanks. dim rng As Range dim VD, VC As Integer dimi as integer VD =...

in my spreadsheet there are a lot of cells that contain a text like "T:\DEPLOY\NETHERLAND\SAPBEHEER\SOURCESPACKAGE\ZCB\ABAP/CLASSPOOL/ZCL_CB_PROJECT/CLASS/ZCL_CB_PROJECT/METHOD/SET_PROJECT_SUB_PROJ" From this cell i need to substract the last part (after the last "/"') in this case...

So I have TAB 1 This contains a load of data broken down by worker. (I don't know how many lines each worker has) On Tab 2 I want it to pull that data through only for a certain few workers. What would be the best method of doing this?

Hey party people, I am trying to navigate and read data from specific sheets from multiple workbooks using VBA. When working with a single workbook, I use SheetX.Select often (X = 1, 2, 3... whatever sheet number I'm looking for at the moment) because the tabs change names, move order, or...

Hi all, From another forum I have spotted a line of code With CreateObject("VBScript.RegExp") Now I was led to believe that if you create an object, you should set it to Nothing at the end of the routine.? However that was always after something like Set objVBSR =...

In Power Query, how can I add a column which merges columns based on a list (so the list of column names gets merged)? If done manually, I would have let Source = Input_Original, #"Added Key" = Table.AddColumn(Source, "Key", each Text.Combine( { [Column1]...

Greetings all, I am trying to run a script which is supposed to delete the visible rows from a table I've filtered. However, when the script is ran it comes up with error msg: :warning: "Runtime error '1004': Delete method of range class failed. :eeek: I have tried it two different ways...

This is a snippet of what I have, but I'm looking for another method that won't ruin formatting on a table. Dim es As Worksheet, WSC As Worksheet Set es = Worksheets("Master Employee List") Set WSC = Worksheets("Testme") r = Application.Match(emp, es.Range("A:A"), 0) es.Rows(r).Delete...

Hi, I'm looking for a method or VBA script to select any cells below a certain value (for example 5.1) in a selection of data. Any help would be greatly appreciated. Thanks in advance

Driving Table TL_Lookup Empl # Name Trad calc Method Roth calc Method AGE Trad Amt Roth Amt Rate 004 SMITH,JOHN Gross Pay 36 22 25 076 CORTEZ,JANELLE Default 49 140 16.5 137...

As the title says, I am seeking to copy a non-contiguous range of cells in columns that are identified by code using Lr (LastRow). The following works, because only the range of B6:C37 and H6:H37 are copied. Sub CopyNonContRange() Range("B6:C37,H6:H37").Copy End Sub When using...

Hi All, I am trying to define a variant based on the results of another loop and I am currently using the below syntax, however i am getting a method range of object failed. I've been trying for about 3 hours to figure this out and have made some changes but can't seem to see what's going...

Programmers, My imported dataset has null values. Currently I loop through the columns and rows; and use this is code: IF .CELL(lRow, lCol).Value = "" THEN .CELL(lRow,lCol).Clear This method takes a long time. Could the .Range &/or Evalute method be used? Something like: With...

Hi everyone, I'm looking for a way to copy an existing file in Sharepoint to the same SP location. I know you can use the ThisWorkbook.SaveAs method to do it from within the file itself, but I need to be able to make a copy of an external file. Finding the folder path etc is not a problem, I'm...

Simple code. I just want it to select a lot of rows and copy them, but I get a "Method Range of Object Global Fail". Sub Copy_h1() ' Range( _...

Need help on a method that will let user select a worksheet from another workbook and move and copy that sheet to the main workbook containing the macro. Note that the workbook is already opened thus activated already and there is no specific name of the workbook as it might have different...

Hi, I've been trying to search for ways on how a userform can function as an inputbox of type:=8 but still got no luck. Basically, what I want is to let the user choose a workbook and a worksheet that is why I use the type:=8 of InputBox method but I want to replicate it using a userform because...

=((Attendance!$D$3*Attendance!D5))+ ((Attendance!$E$3*Attendance!E5))+((Attendance!$F$3*Attendance!F5))+((Attendance!$G$3*Attendance!G5))+ ((Attendance!$H$3*Attendance!H5))+((Attendance!$I$3*Attendance!I5))+((Attendance!$J$3*Attendance!J5))+...

Hello, I am not sure if the title appropriately describes that for which I am seeking. I would like to know if it is possible to do a lookup on a 7 digit number which is part of an alphanumeric string and remove all other parts of the cell that don't pertain. For example, "something 3882712"...