write

I'm trying to write some VBA code but I decided to record a macro to help me as a reference. Later I found that Excel can't capture what I had done and I don't know how to write the VBA code to do it. Any suggestions? I've recorded a short video to describe the problem I met and you can watch it...

Is there a way to keep the formatting, i.e. margins, headers/footers, layout, etc., of the initial Pivot Table and have it carry over to all of the others once I use the 'Show Report Filter Pages'? I have the original one formatted exactly how I want it, but when I have each of the others...

I have this formula, but I'm trying to write into it: =IF(F4<=199, 0, 10) also, if f4 = "Chris" then "N/A" Help please?

So i'm trying to check if a key from one dictionary exists in another, and if it does to write the value/keys to sheets depending on some if statements Loop through all the keys from dicLIVE if that key exists in dicQTY, the key contains "^4", and and the dicQTY value is greater than 8 then...

Was trying to write a match formula with a defined name range. =MATCH("Satisfactory",Yellow, 0) This gives an N/A error. Is it possible? Thanks.

Hi, I am trying to write a small basic code for fuel allowance of 45p per mile. Currently i use this which works fine & correct. =E18*0.45 But i now wish to add the cell value at E34 So i have written, =E18+E34*0.45 The value comes back as £256 but it should be £134.65 222 x 0.45P =...

If I write sendKeys "{^a}" I get "Run-time error '5': Invalid procedure or argument". But if I write sendKeys "{HOME}" it works. Any suggestions please?

How do I write code so that my macro selects all used rows? For example, I have to import data into an Excel workbook every morning and the number of rows are never the same. I need to select all used rows (I do this by manually with ctrl + shift + down arrow) and adjust the row height to...

Hi, I am writing a program in excel VBA where I want to write two for loops together. For example, For x = 1 to 10 and For y = 1 to 10 do something ... Next But if I write "and" between two for statements the program shows error. If I put : between the for statements or write them...

Each worksheet has a named range. How to write VBA code to import/append into 1 access table using the named ranges. I know how to use the TransferSpreadsheet method for 1 worksheet and use the range name, but not sure how tp write the loop to get the multiple range names from all worksheets...

Hi Friends, I Have a userform consisting of some textbox. I wanted to add one feature to the textbox1 like Auto filling when we write. Example : I have a sheet where 2 columns are there. One is A and another is B. I have some datas in these columns as well. So when user starts write in...

Hello, I'm looking for a formula to that would select the cell value right before a cell color change. For example, assume the cell containing the number 300 below was blue, and the 100 and 200 cell are white, how would i write a formula that would highlight all of the numbers (100,200,300) but...

Hello everyone, I have a workbook with around 50 sheets or so. I have code written to hide/unhide sheets based on userform inputs. I am stuck trying to write the code for excel to number the visible pages 1, 2, 3...etc. in cells A9 in each sheet. The visible sheets change and are different for...

Looking for advice and help. I have a user form that can enter, search, edit and delete information that I need to expand on. Currently all the information is stored in 1 sheet, "Data". Which is the source and copy location for a filter for the "master data" (if you will). For example, if I...

Hello to everyone, I was wondering if there is any VBA code or Conditional Formatting for changing the Fill Collor of a cell after I wrote in it. The trick is that I want this to work with a timer. What I mean is that at midnight the cell to become filled with red color and after I wrote...

Hi everyone, I am new to VBA and this forum, so, please forgive me if I'm doing something work. I have been fairly successful with what I am trying to write in VBA, but right now I need some help. Basically, I've been trying to identify the cell number and row in a spreadsheet that matches a...

I have the following 3 formulas. Is it possible to combine them into one or write a macro for them. =IF(LEFT(C:C)="R",G:G&" Rack") =IF(AND(LEFT(C:C)="R",RIGHT(C:C)="B"),G:G&" BLM Rack") =IF(RIGHT(C:C)="B",G:G&" BLM",IF(RIGHT(C:C,1)="C",G:G&" BLM",IF(LEFT(C:C,3)="TRT",G:G&" TRT",G:G)))

hey i have excel already but i need add some vba codes and edite some codes  1 : i have countup timer in my excel.. its working fine, but once i write anything in my sheet, the timer stop, please dix the code. 2 : in sheet 2, there is code, and this code will run only if i write in culm L, i...

So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21 Is it possible to write a code that seperates the 100 and 1000 to another variable?

This was recorded Sheets("Sheet1").Select Cells.Select Selection.Clear Range("A1").Select With ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ActiveWindow.FreezePanes = True Columns("A:A").ColumnWidth = 36 Columns("B:B").ColumnWidth = 36 Is...