Search results for query: *

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!!!

Hi, I couldn't figure this simple Excel to Word problem, please help! In Excel, when you go to print titles in Page Setup, you're allowed to select the rows to be repeated, so the rows that are selected can be printed out on each page. But, I want to copy my Excel list onto Word, and need to...

Dale, thank you so much for your time!!! It really worked. But, if I have a longer series of numbers, I'll be in trouble. Say I have numbers from A1 to Z1. The codes for Move_Go will be so long, unleast I put a loop there. I've been having trouble to write the loop, please help!! Thanks...

Thank you very much Skip!!!

Hi, I've downloaded some data from the Web, and it has a column for time, but it's in TEXT format, so the time reads like this : 102530 (the hour is 10, minute is 25, second is 30). When I tried to change the cell format to "Time" , everything goes to " 00:00:00 ". I've...

Sorry, I was tired...I meant Paste (I'm sure that you know what I meant)...and also I wanted to solve this in Excel without using VBA first. Thanks!!