All Questions
13 questions
0
votes
1
answer
85
views
VBA: remove conditional formatting outside print area
I have many sheets with complex conditional formatting - I would like to automate a way to clear all conditional formatting outside the print area. Does anyone know how to go about this?
In other ...
0
votes
0
answers
35
views
vba excel copy and paste date
maybe simple the solution but suffering from days.
I have an excel sheet with dates, if I check format of it shows Custom / TT.MMM .
This date I want to paste into another sheet but cannot even I ...
- 27
-2
votes
1
answer
2k
views
Copy pasting using Range.Value in VBA formats my text as date. How can I fix this?
I want to copy-paste only the values in a range of cells in Excel.
I am using the assignment method as it is the fastest and perfectly does the job except that it pastes some values which are "12-...
- 31
0
votes
1
answer
388
views
How to copy a row if it contains certain text to the next available line in another worksheet
I'm looking to modify the code below that I received from this forum so that it copies to the next available row on Sheet 5.
Private Sub CommandButton1_Click()
Dim Cell As Range
With Sheets(1)...
- 1
0
votes
1
answer
68
views
VBA Array function returns error due to column formatting
I have created a database that takes a number of templates saved in a directory in csv format convert them to xlsx into a holding file then load into a log within another file. Within that file is a ...
- 15
1
vote
0
answers
334
views
Using VBA WordEditor to align multiple tables horizontally in Outlook
I'm trying to use VBA WordEditor to compile an Outlook e-mail which copies some tables from a workbook and pastes them into the e-mail. I'm trying to make the table objects lie on the same horizontal ...
- 23
0
votes
1
answer
8k
views
Excel 2016 - Paste option to keep source formatting is not available
For some reason, my colleague has Excel 2016 and has the Paste option to keep source formatting. Right click on Mouse > Paste Options > Keep Source Formatting (K)
I have the exact same version of ...
- 537
1
vote
4
answers
27k
views
VBA excel paste as text
I need to paste numbers as text. It is problematic due to lots of zeros in front (but I need them there). First snippet, does not work (I found it on the internet).
Worksheets("B").Range("k7:k7")....
- 33
0
votes
3
answers
2k
views
VBA to Paste format from original Workbook to new Workbook
I hope you can help. I have code below. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then ...
- 651
0
votes
2
answers
64
views
VBA copy paste formmating and formulae
I am quite new to VBA, the code below is what I have managed so far but I would like to ask if someone can help with formatting and formulae copying please?
I have the below code running in my ...
1
vote
1
answer
186
views
Trying to copy Formatting in all cells from one Excell sheet into another specifically keeping fill and text color using VBA
I have a working VBA script that copies exactly what I need except formatting. I at least need it to copy Fill and Text color.
Here is my current code.
Private Sub Workbook_Open()
Application....
1
vote
1
answer
7k
views
VBA Code - Retain Formatting for data copied to different sheet
As a new user of VBA in Excel I'm trying to complete the following:
1) Check multiple rows of one column in a sheet called "Index" for a condition (My condition is to look for the letter Y in cells in ...
- 37
1
vote
1
answer
5k
views
Retaining superscript formatting on on .PasteSpecial
I am copying a range from one workbook to another. As much of the data in the source range is a formula I need to paste by value:
With TargetRange
.PasteSpecial Paste:=xlPasteAll
....
- 39.2k