Description:
Microsoft Office Excel newsgroup.
|
|
|
Storing values
|
| |
How can I store calculations using a currency exchange rate (stored in A1 for example) but not have the result change when the exchange rate is update?
I do not want to store each exchange rate variation in a new location every time it changes.
|
|
|
Loop to skip some sheets in workbook
|
| |
What do I put where it says 'DO NOTHING so the loop will skip ws. X, Y & Z?
Thanks,
Howard
Option Explicit
Sub LoopThroughSheets()
Dim ws As Worksheet
If ws.Name = "X" Or ws.Name = "Y" Or ws.Name = "Z" Then
'DO NOTHING
Else
'Do some code stuff here like:... more »
|
|
|
Vertical scrollbar screwed up
|
| |
Normally when I drag the vertical scrollbar down to the bottom position it goes to about line number 150 or so, depending on how much data I have in that worksheet. But on one worksheet it suddenly and mysteriously changed to scrolling down to line number 1048576. I don't know what I did to make it do that. How can I get it back to normal? I... more »
|
|
|
VBA Macro to customize Right Header
|
| |
Hi! :-)
I have spent the last few days trying to make a macro in vba to customize the right header, in a excel sheet with multiple pages, but without much success. :-(
I need some help to do the following macro:
"In first right header page": N. M001 a M002
"In second right header page": N. M003 a M004... more »
|
|
|
MS Query
|
| |
I have created a Workbook(A) which extracts data from different
workbooks(B to G) by using MS Query and stores in Workbook (A)
Workbook(A) is sitting on Server A.
Workbooks (B to G) are located on N, O, P, Q, R, S i.e. 6 different
servers on 6 different locations in 6 different cities.
Workbook(A) has a macro assigned to run the MS Query (Refresh all)... more »
|
|
|
Standard column width in points...
|
| |
Hi,
I can read the standard column width of a sheet with ActiveSheet.StandardWidth
...but this gives me the width in chars....
How to get the standard columnwidth in points?
TIA,
CE
|
|
|
Compare shorter date range against longer date range
|
| |
Hi Excel Gurus !
I am in need of a macro / formula which is able to find the missing date range(s).
Example:
John stayed in Apartment A&B for period : 1 February until 15 September.
Rental paid shown in records :
Apartment A rental period : 1 January until 28 February
Apartment B rental period : 1 April until 31 July... more »
|
|
|
Columnwidth in milimeters?
|
| |
Hi,
Is it possible to _READ_ the width of a column in milimeters?
I can get it in chars, pixels and points, but how to get the width of a column in milimeters???
TIA,
CE
|
|
|
Loop thru folder and get similar names
|
| |
Hi,I have a requirement that i am trying to code,i have 2 environments
beta and prod that has reports (30+).these reports are in .xls
format.Eg:Beta report:AUD210ba_-_Research_Rat ings_Audit.xls and prod report is AUD210ba_-_Research_Ratings_Au dit_Prod.xls.similarly
with all the reports.the requirement is i have to browse thru the... more »
|
|
|
