I have a spreadsheet where I have text in a cell. I created this file a few weeks ago and have been in and out of it several times with no problems. I was in it yesterday and made a few chan...
I have a cell that depends on another formula in another cell if there is no data in the latter cell the former cell displays #VALUE!
Is there a way that I can ensure that that cell the is ...
In reading through old questions I believe I read that hidden sheets CAN be accessed by VBA procedures. That makes sense to me.
However, I encounter an error when I attempt to Select a hid...
What this macro is meant to do is every 5 minutes it will run another macro (Zip_ThisWorkbook) which saves and zips the workbook.
The problem is after I close the workbook the OnTime macro ...
Hi Guys,
Can you help. We have a large excel doc, with 20+worksheets. Each worksheet is several hundred lines. Is there a quick way to create a shortcut to certain cells within each work...
Ok guys, I am stumped. I am sure there is an easy answer, but I just can't find it. I'm new to programming, I have seen some code on here that might have worked, but it made my head hurt!! ...
Hi experts,
I have an excel workbook, that has sheet1 and sheet2:
I require to read the 3 cells (A1, B1, C1) from sheet1 and insert them in sheet2. This requires inserting them as new rows a...
Hi,
Excel macro that when run opens the excel with Admin credentials.
This files saves and closes after entering the credentials of an administrator. Does not open.
Regards
Sharath
I have a merged range (e.g. a1:c1). The value of the merged range shows up when you select a1. When you reference, c1, it shows up as empty.
How can I determine in a VBA FUNCTION (not sub...
Hello all, I have two macro questions
1) How to run a macro automatically (auto_open I think?) on a spreadsheet if the macro is located on another spreadsheet?
2) Once the macro is run on ...
I need to be able to select a range of columns in Excel using VBA, but using R1C1 format.
For example: I want to select columns 2 - 5 (which would be columns B - E).
If I don't use R1C1...
I would like to run a macro or vba code to change the colour of a range of calls H30:I30 when the user selects a value from a data validation list which is in merged cells F27:H27.
So when th...
I have a file (attached) that has a count of items by SEC_CODE (two letter field) and an RP_Code, numeric value between 0 - 9999.
I want to sum each SEC_CODE by ranges of RP_Code. (1000's)
S...
I have an Excel file that connects to our SQL Server DB to pull data in which in turn drives metrics charts. I would like to distribute this Excel file to my co-workers so they can use t...
I have an Excel VBA app that creates and displays a chart on a new form to the user on the fly. The chart has 2 series plotted on a line graph. Both of these series have the same number of poi...
In Microsoft Excel 2002, I have a spreadsheet that I would like to print with alternate lines (or perhaps every third line) shaded in grey in the background, to make it easier to read lines ac...
Hi expertsm hope you can help
I'm having a bit of trouble to implement the code. It does what it should do but I would like to set an offset. So once it comes to the end if the row where the ...
I have this dynamic named range in excel which is define like this :
=offset(A1,0,0,counta(A:A),counta(1:1))
Now I want to link this to an Access table. The range doesn't show in the Access ...
I have to base a cell color on what % the number corresponds to by dividing the number in the cell by the number in another worksheet. Here's the formula for example - 'Sheet1'!b8/'Sheet2'!B2...
Hello,
I am trying to write a statement in excel which is going to be something like this,
=IF(X3="RP",IF(OR(G7="A",G7="B",G7="C"),"1","0"))
However the formula works if X3 is RP but ...
I have a snippet of code which works perfectly, except that it is extremely slow!!, can anyone speed things up or use a coded autofilter, idealy I would like to copy the data from sheet1 to sh...
When I export an Access database to Excel 2003 (format) the resulting Excel spreadsheet text fields have a hidden leading single quote.
I can't Find and Replace this single quote (Excel doe...
I want to apply conditional formatting to a column of figures based on a formula which has to refer to other cells and one of those cells contains the operator for the formula.
E.G.
=B2>D2 w...
I have an Access 2007 run-time database that includes rich-text format memo fields. I need to use the memo fields in an Excel 2003 workbook via linked queries to build and display it as form...
I have a some vba code that creates a chart on a worksheet. When I protect the sheet with "Allow all users to edit objects" turned on, in Excel 2003 it works as expected, but in Excel 2007 it...
