Recent content by risk99

Hi, I am designing a document template which has 5 paragraphs, and there is a name which appears in every paragraph, but I don't want to type in the same name 5 times repeatly. So, is there a way (like the the formula functions from Excel) to link all these 5 sections together? For example...

Is there anohter way that I can just do it within Outlook? Thanks!

Hi, I try to send an attachment (different files everyday) to the same recipents everyday after a certain time of the day (day after 5pm). I am sure it's doable by writng some VBA codes (I've never written anything for Outlook, but have some experiences from Excel), and I've tried to record...

Hi, I have two time series for two data sets. For example, I have historical prices of gold and IBM. Sometimes you have extra trading dates for gold, or IBM, and I want to delete extra prices, so the two will be aligned with the same amount of data points (final format will be dates in column...

Loomah, THANK YOU VERY MUCH!!!

Ok, let's say I have my data from B1:B20, and I select the range, then run the macro. But, it doesn't work. Thanks!

Hi Skip, Can you be more specific? I'm still having dificulties to run the code. Thanks!

Thanks for all the quick reply, I've tried this, but it didn't work, please let me know what's wrong. The error is in the line with Range("i:i")..... Option Base 1 Sub delete_row() Dim i As Integer, n As Integer n = Selection.Rows.Count For i = 1 To n...

Hi, I have data in three columns, and want to delete the entire row if the cell on column three is empty, and shift everything up. My aproach is to select all the data in column three, and count the number of rows, then create a "for" loop to delete the rows. Please help! Thank you!!

Hi, I was told that I can change the source data by dragging the series points from the chart's plotting area. I've tried, but it didn't work. What do I have to do? Thanks!

Hi, my workbook has about 30 sheets, and each sheet has lots of formula and links. I'd like to save the workbook for the other people to see the info only. Is there a way that I can just save as in values? I don't want to protect or hide any of the cells. Thanks!

Anyone? Thanks!!

Hi, is it possible to tell VBA to download data from a Site which requires user name and password? Thanks!

Hi, I was performing the find and replace function. I hiligted a column and performed find "K" to replace with "L" and hit the "Replace All" button. At this moment, I'm not sure if that was what I did...because there is this poped up "File Not Found" window on my screen, and I can't cancel the...

Guys, Thank you very much for all the inputs!!! PHV and Tony, thanks a lot!!! That was exactly what I wanted, have a great weekend everyone!!!