I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here:
Range("A3:D19").Copy Range("E15").Resize(14 *...
I'm attempting to copy an Excel cell, and paste it into another program (in this case, Adobe Analytics). However, it's inserting a space after every newline. Ex:
Instead of this
-It does this
(but instead of "-" it just does a space)
When I paste it as text to MS Word, and...
I have the below formula that am trying to paste but for some reason is not taking =, what am i doing incorrect
See sample link
the sheet is called Raw Data but is calling from calculation...
I want to open an application with any code in attached and want to send these number one by one through that application!
That application is bushbullet, which linked with my mobile msg box! https://www.pushbullet.com/ for more understanding!
When I hit button in sheet that call...
Any help here would be appreciated greatly.
1 Copy Item A from List A
2 Paste flat to B2
3 Recalculate the result to update C2
4 Copy range B2:C2
5 Paste flat to bottom of List B
6 Goto next cell on List A
Repeat steps 1-6
Stop at bottom of List A...
Set Template = Sheets("Template")
Sheets("Template (2)").Name = "ABL"
The code above is working to copy one sheet and move to a new sheet. However, I want to paste into the new sheet as values. I'm not sure how to do that...
I keep records of electricity, gas and water consumption, which at the moment are on individual spreadsheets. I want to create a functioning spreadsheet of three original sheets to contain those I first mentioned.
Copy and paste seems not to work, as each new item posted to the recipient sheet...
I have an SQL statement that sums up two fields and is working find in SQL
Select w.Forecasted_hours + w.actual_hours as 'TotalForecast'
however in VBA I'm not exactly sure what would be the right way to do it. If I paste the SQL it seem like not recognizing a plus sign.
Can anybody please...
I'd like to copy the text of a formula in a cell, then paste that text into a cell in a different workbook, without the formula changing.
I can't use 'copy' then paste special xl paste formulas, because the reference changes when the formula is pasted into the other workbook.
I want to paste two ranges into an Outlook email.
I can create the email, filter for the range, copy and paste the range.
The problem is with where the second range pastes.
In the first three emails, everything works correctly. Then, the code does not correctly find the end of the message to...
On my worksheet called Sheet1 i have a range I26:I35 with values in.
My intensions are to press a transfer button on a userform & select a Month.
This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here.
Is there an option to remember the last thing i copied and paste it after doing several actions in between ?
For example > I have to copy some text and paste in one cell, than i change...
I would like to copy all non-blank cells in range R5:X7000 into the adjacent cell in Range K5:Q7000 as paste values. Essentially any non-blank cells will paste as a value in same row but 7 columns to the left. I have what I think is a good piece of code but need some help how to edit it...
There is any code or vba or formula which can do the following
1. We are copying a data/formula
2. Now we want to paste it as values in a active cell,
My problem is that every time data size is changed so formula/code/vba will work when we use that command/vba/code for paste values on that cell
In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that.
Sorry cannot paste table into here
Thank you for any assistance
I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...
I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find...
I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format.
Here is the current format:
<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt...
I am currently working on pivot tables and charts. I have charts on one sheet and when I copy a pivot table and paste it onto the charts sheets the charts expand. How can I prevent the charts from expanding when I copy the pivot table or for that matter any text.
The expansion is...
I have a form that adds data to a table, I have a macro that adds a new line to the table, but I would like to copy and paste as value the previous line once I've added a line. When I record the macro though it puts a specified range in but I would like to just have it say go up one line and...