rangem

Name error I’m trying to use VBA to test if cell (in the active row) [C] has no number in it or is blank, and also test if [F] has a number in it. If true then copy the condense of [F] to [M]. Everything seems to work until it get to the last line “copy “F” to M” I get a #NAME error...

I’m trying to use VBA to test if cell (in the active row) [C] has no number in it or is blank, and also test if [F] has a number in it. If true then copy the condense of [F] to [M]. Everything seems to work until it get to the last line “copy “F” to M” I get a #NAME error. Thanks. Sub...

Hi, again I’m new to macro writing so please be patient with me. Thank you!! What I have is: I have sheet 2 as my active sheet Sheet 1 as my source sheet What I need to do is: Read column A in sheet 2 and for every item in column A I want to look for it in sheet 1 (source sheet) column A and...

Hello, I am new to macros and this may be a simple question, hope you can help. PLEASE!! Thanks! I'm trying to search for any string with a ":" from column M and move it to column D but start at a specific row based on a search i have. For example: This finds kis emr and returns the row...

Hi All, my query is to copy and paste the data in other work book whereas some of columns need to be hidden before pasting the data. I have used below code but not getting prom results code : Workbooks("CustomReport").Activate...

Hi, I have this code: For rw = 2 To num Application.StatusBar = String(3, ChrW(9609)) & "Scrubbing at row " & rw & "/" & num & "." If InStr(Range("L" & rw).Value, "1") > 0 Then Range("A" & rw).Value = "#" Range("K" & rw).Value = "#" Range("M"...