changing

I'm using this to add a picture to a Word Table cell; oDoc.Tables(1).Cell(1, 2).Range.InlineShapes.AddPicture "C:\Users\James\Desktop\Hampshire.bmp" Can someone please show me how I can fit the image to the cell dimensions without changing the cell in any way?

I have failed using previous similar messages..... I need a code with Set Cell - Q17 To Value - Q2 By changing - B2 Appreciate any help you can give on this Regards Matthew

Hi, I have a number in cell A1 which keeps changing.. Whatever that number is, I want excel to list 1 to n automatically as the number keeps changing.. Example, if I have 10 in cell A1, it should list 1 to 10 from C1 to C10.. if I change it to 20, it should list 1 to 20.. change it back to 15...

I have formulas that adds up numbers in a range. The size of the table changes day to day, normally about 200 rows, so originally I wrote the ranges to be $R$5:$R$500 to have space to grow.. Today I noticed that it had changed to $R$5:$R$146. I have this same formula 30 times, with minor changes...

I have a macro: Sub apply_autofilter_across_worksheets() 'Updateby Extendoffice 20160623 Dim xWs As Worksheet On Error Resume Next For Each xWs In Worksheets xWs.Range("I2").AutoFilter 9, "=0.00" Next End Sub As you can see, I didn't write it, but I understand the...

I'f I'm trying to show records like 1-0 2-0 3-0 etc without it changing to another numerical format how do I do that? Appreciate the help.

I am using the following code to change the name of a tab dependent on cell values. However it only updates if I leave the tab and come back to it. I would like it to update immediately upon the information in the cells changing. Private Sub Worksheet_Activate() ActiveSheet.Name = ("Stage 1...

Hey, I am looking for a formula to copy value from specific cell to another. For instance <tbody> A B C 1 Copy Me 2 Copy Me 3 </tbody> I want in B to copy cell A2 and C to copy cell A1 regardless of the values that will be changing in just cell A. So whatever changes I do in cell A...

Help! I am trying to change cell colours using conditional formatting but it's not working. I have an 'IF' formula in one of the cells I'm trying to change colours on so I'm assuming that's why. It's changing all the other cells except the one with the formula. Is there a way around it please?

Goal Seek is not working correctly for me for some reason. For example, take the three cells: A1, B1, C1. C1 = A1 + B1 A1 = 1 Now, I start Goal Seek and use the following information: Set: C1 To value: 8 By changing: B1 Instead of Goal Seek changing B1 to 7 (1 + 7 = 8), I get the...

When I'm creating a Pivot table some of my numbers default to count instead of Sum. Is there any way I can fix this in a setting so going forward I don't have to keep changing it or do I need to change the value settings every time? Thank you

Is there addin or a vba code which help me in changing the address of the linked sources (excel sheet) in power point.

Hello, I created a form in access and was scrolling through the records, but I don't see any records. There are 4 records in the table tied to this form, but while scrolling to the next record it is blank. What am I missing? I see the refID changing and the date reviewed is also changing but...

Hi there, I would appreciate your help in following. I need to calculate the sum from "Values" field in pivot table to the cell outside of pivot table, which stands for exchange rate and changing every month. Does it make sense? :) getpivotdata doesn't work ((( neither calculated field

Please i'm having problem of changing my Orientation (landscape or Portrait) on page layout is not changing hw do i solve it

Hi What-If-->Goal seek (not scenario), set the value of a cell by changing other cells (not only one)? I tried but it seem not working only one value is changing. I think it is not allowed only using Scenario to change 2 or more cells, Am I right? Thanks alot

Hi all, I am currently using the formula =INDIRECT($C$2&"!A1") which works fine. what I now need is for the box below to be =INDIRECT($C$2&"!A2") and so on, down until A330 is this possible without manually changing the A1 to A2, A3, A4 and so on? Thanks Rick

Is there a way to add protection to a sheet that already has certain restrictions for normal users, to prevent them from changing the font and size of all cells in the workbook? thanks for any help