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

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

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

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

Many of our users use Visual Studio to speed up development and help organize their code. It’s a flexible development platform, and version 2012 adds tools...

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

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

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

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

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

I have a complicated problem. I'm trying to loop through several directories to find a particular file. Here is a sample of my folder structure...

Hello everyone, I wonder if you please could help me with a macro; I just started to use VBA, so my knowledge is equal zero. I have a workbook with a few...

I have used this very line of code successfully in other macros but here it errors out. With cursor at the end of that line, Run DeBug - run to cursor gives...

This code works fine on a list with a Header in column A. Copies the Header across the same row, starting 1 column to the right for as many columns as there...

Suppose I want to select a specific range, such as: Range("B10:Q10").Select The above range exists on row #10, between Column B and Column Q. In...

Hi, i'm new to VBA coding. The situation is that I have a file that comes in every week with the same number of column, but with different number of rows . I...

Hello all, So I have a sheet within a workbook that I am wanting to save/publish as a PDF file. the code i have thus far is : Sub Publish2() ' ' Publish2...

This might be a dumb question, but here goes.... If I run this code: Range("A12:M2").Select is there a command that will "undo" or cancel...

Hi Got a cash sheet and want to put names addresses and email addresses of people in it but by the time I've got a column for each of these (the address...

Is this the only way to determine if a userform is visible? : if (Userform.Visible = true) then ' code here end if The problem with this code is...