目前分類:title (3013)

瀏覽方式: 標題列表 簡短摘要

I want to know if I create an Excel User Form through the Visual Basic
Editor, but I don't have Visual Basic install on my PC. Can I still do it and

software 發表在 痞客邦 留言(0) 人氣()

I am preparing a lengthy list which inlvoves social scurity numbers and would
like to know if I have typed in a duplicate without doing a search each and

software 發表在 痞客邦 留言(0) 人氣()

How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.

software 發表在 痞客邦 留言(0) 人氣()

Hello,

software 發表在 痞客邦 留言(0) 人氣()

Column A has several hundred fixed numbers. Columns B-infinity contains some
of the numbers in column A. I want to sort colums B-infinity so the rows

software 發表在 痞客邦 留言(0) 人氣()

I am trying to parse addresses into their basic components (I.E. quot;123 Main
Streetquot; becomes quot;123quot;, quot;Mainquot;, quot;Streetquot;) in an Excel Spreadsheet, for later

software 發表在 痞客邦 留言(0) 人氣()

How do I create a list box within a cell of state abbreviations which i can
then use as a lookup reference for a formula applying tax rates.

software 發表在 痞客邦 留言(0) 人氣()

I have a worksheet with several columns on it. At the end is a total column.
The formula adds all the numbers across to make the total. I want to move

software 發表在 痞客邦 留言(0) 人氣()


I have a column of numbers in which I created 2 different Moving Average

software 發表在 痞客邦 留言(0) 人氣()

I have a large spreadsheet and I am trying to add a macro that allows me to
add a worksheet AND have an input box pop up so I can name the worksheet

software 發表在 痞客邦 留言(0) 人氣()

I have a list of various food in Sheet!1 A, and the calories are listed in
colomn B in Sheet!1.

software 發表在 痞客邦 留言(0) 人氣()

Hi, I am writing a macro to expand/collapse a group of rows.

software 發表在 痞客邦 留言(0) 人氣()

Excel 2000

software 發表在 痞客邦 留言(0) 人氣()

I have a problem with VLOOKUP looking in sorted lists of more than 16384 items.
Basically it fails at 16385th item

software 發表在 痞客邦 留言(0) 人氣()

My file won't allow me to quot;conditional formatquot; or run quot;protectionquot; anymore.
I did have a password on it and that option is gray as well. How can I

software 發表在 痞客邦 留言(0) 人氣()

I am having problems getting all the files in the XLSTART folder to open up
with Excel. It used to open up all three that I have in there, but now it

software 發表在 痞客邦 留言(0) 人氣()

I am looking for a template for the 2006-2007 academic year

software 發表在 痞客邦 留言(0) 人氣()

I have a date (say current month) and I want to check to see if that date is
before, after or in the same month as other dates found in other cells.

software 發表在 痞客邦 留言(0) 人氣()


Since today I am facing some peculiar change in my excel files. When I

software 發表在 痞客邦 留言(0) 人氣()

I want to lock worksheets for outside users. But when I do it and a macro
needs to go into the worksheet, the system gives an error. So is there a way

software 發表在 痞客邦 留言(0) 人氣()