$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread netuser1110
Leaving Outlook + high speed Internet connection open 24/24, you put yourself at risk sending Buy Viagra spams or any other less or more serious risks! On Wednesday, June 6, 2012 11:48:03 AM UTC+1, bpascal123 wrote: > > I'm trying to figure out something related to Vba instead of a new > script

$$Excel-Macros$$ Merge 2 sets of data

2012-05-22 Thread netuser1110
Hi all, I have a task that I can achieve up to one point using vlookup but afterwards I need to manually add rows or columns to update the data with a new set of data. It is understood the from the first set nothing should be deleted. Even if one row is empty from the first set is not present

$$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread netuser1110
Hi, Does anyone can explain me what this loop does and more specificly the "InStr" function the way it is used below : For Each Cel In Rng1 If Len(Cel) > 0 Then If InStr(1, TmpX, LCase(Cel) & Chr(171)) = 0 Then TmpX = TmpX & LCase(Cel) & Chr(171) n = n + 1: