Microsoft QuickTips
< 1 2 3 4 >

Visual basic/excel - inserting system date into excel field?

I need to insert a line in an vb excel macro that inserts the system date (date only, not time) into fiels in excel. if the field name is h15 and the worksheet name is sheet1, cou...

Excel query - selecting a specific tab from a drop down box?

Hi all you excel wizards, i have a spreadsheet that contains, say 26 tabs, each being named a different letter of the alphabet. in the 27th tab i have a scroll down box, or a da...

Excel problem?

If anyone can be so kind and give me clear and simple step by step instructions i would be so grateful. using excel for the first time and this is the prob: received an excel sh...

Excel: is it possible to get excel to auto x and /?

I'm typing in information and i hoping theres an easier wayi mean i'm currently repeating myself with a small difference, (my sheets on food) e.g. for e collum i do 114/100* x ...

Excel spreadsheet?

I copied an excel spreadsheet from a website into ms excel. its clearly locked but to try and understand how it works i need to unlock it, if indeed that's possible, to vie...

Excel enquiry?

I have a massive data set which i need to statistically analyse. when i copy the raw data into excel it occupies one column even though it appears as three columns inside column a...

Excel query - selecting a specific tab from a drop down box?

Hi all you excel wizards, i've a spreadsheet that contains, say 26 tabs, each being named a different letter of the alphabet. in the 27th tab i've a list box that contains the na...

Excel 2003 vba problem on startup?

When i open excel 2003, i get a message saying that a component could not be installed and it asks me if i want to install now. if i click 'yes' the component installs, but it asks...

Excel file - error message 'unable to read file' ... why?

This file started life as an excel spreadsheet in excel 2004 for mac and was saved as such. it has the extension .xls and the info all seems to be fine. virus checks did not show a...

Excel- text all on the same line?

I'm trying to keep text all on the same line in excel without it going into the next cell.i also do not want to modify the cell in anyway (height/length).just trying to keep all te...
< 1 2 3 4 >
 
< Back
Microsoft Quick Tips Blog -|- Hostgator Web Hosting -|- G -|- Answerz