instr()

I'm attempting to import comma delimited data into an array but need to replace the 187th element of each line if the total number of commas in the string is equal to 192. The problem being that I can't determine the number of commas in the string. Sample .txt file ...

Hi! I've been trying to solve this problem for a couple of days now without any luck. I wnat to search a range of cells based on their values. But somehow the instr() function wont work, I've used it earlier with sucsess, so I don't understand why it wont work now.:confused: So far I'm just...

My client sends me a spreadsheet every month and I am trying to run a macro where it searches for a number within a cell. In the below example I have labeled the headers as (Type - Acct #), and then there is data below the headers. Sometimes the client changes the account name. For example...

My client sends me a spreadsheet every month and I am trying to run a macro where it searches for a number within a cell. In the below example I have labeled the headers as (Type - Acct #), and then there is data below the headers. Sometimes the client changes the account name. For example...

Hi, I am quite a newbie on this and try to step up to the next level... The sub below tries to compare a list of new transactions on a worksheet with a second list on another worksheet. If a condition is met it should copy a range from the second list to the first. I tried to write it all in...