Tagged Questions
1
vote
1answer
36 views
Check multiple columns for values then perform operations on them
I have an excel sheet with values in ranges E10:1610 and if cell J5 is equal to "Yes" I want to use vba to check the entire range of columns for values higher than 10. Add all these values together ...
3
votes
0answers
42 views
PrintOut prints groups of sheets instead of 1 group
We have this problem on many workbooks where we select a few sheets with VBA and print them using the following line and Excel will actually print multiple groups of pages instead of 1 group of ...
1
vote
1answer
25 views
VBA: How to delete filtered rows in Excel?
I have an Excel table that contains some data. By using next vba code I'm trying to filter only blank cells in some fields and delete these rows
ActiveSheet.Range("$A$1:$I$" & lines).AutoFilter ...
1
vote
2answers
50 views
Close/Release Word object in VBA?
I have the following code to open the manual for an Excel Workbook application I have developed:
Sub OpenManual()
'Word.Application.Documents.Open "\\filePath\FormFlow To ...
0
votes
3answers
47 views
How to Loop Through 5 Cells in a Row Using Excel VBA
I want to loop through 5 cells, Q5 - U5.
With each cell I want to check if the value is equal to "Y", and if yes, highlight the cell to make it green.
How may I do so? Can't seem to figure it out.
...
1
vote
3answers
37 views
How to Automatically have Text Cursor in Text Box (as Opposed to Command Button Selected) in Form?
I have two Excel picture objects linked to different forms, each with a text box and OK/Cancel buttons. In one form, the text cursor is in the textbox when clicking the object which is what I want:
...
0
votes
2answers
67 views
How to fix my spacing issue when writing to .txt file?
I have created an Excel Workbook with a macro designed to export all data from a worksheet to a fixed-width .txt file.
I've got everything working perfectly except for one thing. My XWGHT field comes ...
0
votes
1answer
46 views
Save Excel cell value of M/DD/YYYY as MMDDYYYY?
Say I have a cell with the value 5/29/2013 as Text. When I click my form control "SAVE" button, I save that value into another worksheet cell (set the other worksheets cell value equal to the one with ...
0
votes
1answer
39 views
Alphabetize values in pivottable drop down in Excel using VBA
If you have a pivot table set up and you click the drop down for a field, and looking at the value filter section that shows up, I would expect and want this to show up in alphabetical order. For ...
0
votes
3answers
54 views
Stop Excel Converting “22/50” to 0.44
I have an Excel "Application" that on save takes the value from my "Form" worksheet and saves it to my "Data Table" worksheet.
I noticed when the original record value of ...
0
votes
0answers
63 views
Alphanumeric Sorting for multiple columns
Can anyone help me with an alphanumeric sorting code (ascending based on numbers) for multiple columns sorting (column by column sorting).
Please note that, I have thousands of columns that need to ...
2
votes
2answers
46 views
Excel VBA renames the wrong sheet
I have an excel macro-enabled workbook that has 5 sheets. One of these sheets is named "NC" and one is named "SC". I have part of the code which adds dates to these sheets' names.
Sheets("NC").Name = ...
2
votes
2answers
113 views
How to make a VBA custom function return nothing - not 0, not a blank string, but nothing
I have a custom function to be called from inside a spreadsheets' cell, that I want to return nothing in some cases. In other words, I want the cell with my function to be treated exactly like an ...
0
votes
1answer
23 views
Copy data rows from excel files
Hi, everyone!
I have a directory with files.
Every file has one worksheet.
I need to copy specified row (e.g. G:G) from every file to one master_file.xlsx (from where I start my macros).
One of ...
0
votes
1answer
56 views
excel paste special function in vba not pasting cell widths
I'm running a macro to copy from one sheet and past to another however, it is not pasting the cell width. If I do this manually it works i.e. copy the column and paste special > all. the vba code ...
