In Access 365 I import data from a CSV file into a table "tblImport". I took the defaults when setting this up so tblImport fields match the column headers in the CSV file exactly. The fields are somewhat cryptic so I added text to the 'Description' field in the Table Design. I would like to...
When I filter a table and try to delete just that row, Excel always asks me if I want to delete the row on the entire worksheet. The only solution I know of is I have to clear the filters, delete that row in that table, and then re-apply the filters. I posted about this a while back and got my...
I think the tl;dr would be, how can I have Excel prompt me to take some action and then wait until I've completed the action?
I'm writing a subroutine to re-sort columns in a table. I would like to be able to set it up such that the user (me) starts the macro and is prompted to click on a cell...
I'm trying to copy a filtered table to another worksheet. I only want to copy the filtered rows, but I also want the formulas to reference the new table, not the old table.
From what I've seen, the only to copy formulas from one table to a new table correctly is to use PasteSpecial...
One annoyance for me is not being able to delete a table row when the table is filtered and there's another table occupying the same row on that same worksheet. So I was going to write a macro to do this for me.
I searched the internet and couldn't find another solution so of course I came...
I have an Excel (Office 360) workbook with a lot of macros. Currently the macros are triggered by buttons on individual worksheets. I'd like to migrate many of them to a custom toolbar for this workbook.
In the past what I've noticed is that some Excel workbooks with a custom toolbar leave it...
I have a structured table that looks a bit like this (the dots are so everything lines up here):
Column1..|Column2 ..|Column3...|Column4...|
Info.....|Info......|Info......|Info......|
Blank....|Info......|Info......|Info......|
Blank....|Info......|Info......|Info......|...
I'm working on some code to interface with some 3rd party software called "HYSYS". The software is installed on another computer and as such the required type libraries are installed on that computer as well. When I want to work on the code on another computer that doesn't have the libraries...
I have a table of data. The only odd thing about it, I suppose, is that column A is not completely filled with data. There's an entry ever 2 to 50 rows; it just depends and it's not something I can depend on.
I'm trying to create a structured table around this set of data. The ActiveCell is...
I have a table of pipe data. The data includes the Pipe Size, Outer Diameter, Inner Diameter, and Wall Thickness.
For pipeline related calculations, a minimum wall thickness is calculated for the given service. I need help creating a formula that will pick the next highest wall thickness for...
So I've run across this issue before and wasn't sure if there was a workaround.
In this example on stackoverflow, https://stackoverflow.com/questions/38018232/send-keys-is-disabling-numlock (scroll to the end of the comments for the example code, there's an IF statement in the API declarations...
I created a new table style and saved the file as book.xltx in AppData\Roaming\Microsoft\Excel\XLSTART
When I start Excel with a blank workbook, the custom style doesn't show up.
I put a copy of the file in \Documents\Custom Office Templates also.
Are we not able to save custom table styles...
Not sure if this should go here, or the Query forum, or the VBA forum, so... let me know if I'm in the wrong place.
I have a form, put a button on it, and clicking the button runs a query. The query asks me for a date. I want to have Me.Date somehow make it into the named query. Not sure how...
I have a table that, when sorted, needs the rows to be autofit so they adjust to the user can see what's in all the rows and such. Not every row has extra info, so when the rows get sorted/filtered, etc. they don't keep their individual row heights. By the way, if there's a way around that...
Not sure I phrased it correctly in my subject line.
I was wanting to be able to set the formula error checking options on a certain workbook, but not on ALL workbooks. I found this object, ErrorCheckingOptions but I'm not sure I understand its application (no pun intended, see what I did there...
I have a spreadsheet with a list of different chemical species, things like methane, ethane, propane, etc. I have functions/calculations that will take that list, reference physical properties on another sheet, and give results to the user. There are different equations that can be used, so I...
So I wrote a little code to run through a table and trim all the cells. As has happened in the past, Excel will "lock up" during code execution so I can't tell if it's still running, confused, broken, or angry. (Does Excel get angry? Perhaps, heh.)
I learned a few months ago that putting in...
So the data I'm working with has a column with lengths of pipe written like this: 5'4"
The procedure I copied off the internet (quite thorough and lengthy, let me know if you want the link) will parse that into decimal feet, but it requires a separator between feet and inches. So I do a...
I've always had issues with 'Range', something about it has always frustrated and confused me, so for this particular bit of code I'm using "Cells" which makes complete and total sense to me, heh. Anyway...
In Excel 365 I'm running down a series of rows. I check in Column 8 and if there's a...
I'm parsing through a spreadsheet and I need to check if there's an instance when one cell has something in it but the other is blank. There are instances when both cells have something in them, and instances when both cells are blank. That's OK.
All I can come up with is something pretty...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.