selection range

Hi Mr. Excel Family, I know I am overthinking this and its probably simple so here goes: I am trying to set "ChartRange" as a range that includes cells H5:K5 and everything below as the range of cells to use in a chat. For some reason, I can't figure out how to select the original range and...

I have a simple public function within a module. I am planning to execute the function as a user defined function within a worksheet. For now, I only need to select a cell and get its content. This is not working correctly and I hope someone can enlighten me. The simple code from the...

Hi all, I have an excel file that populates a quotation sheet using several user forms that refer to source sheets (products, accessoiries, work/hours, etc.) The view mode of the quotation sheet is set to "Page Layout". I run into an issue when one of the userforms wants to paste something...

Hi all! I have an excel file where I have to change Katakana characters to Hiragana. I've been using StrConv + vbHiragana for some time, however, it is really slow since I am using it in a range for a 1000 rows (two times). After searching around, I've found the following code, which seems like...

Hi all, so I am trying to resize the selection to equal a number of rows and columns specified in cells C45 and C46, respectively. My code gives me a 1004 Object Orientated error. Does anyone know how to fix this? Sub TableExpand() Worksheets("Sheet1").Activate numrows =...

Folks, Subtotal is superior to Sum, yadda yadda yadda. But Sum has a convenient button. When you click it, it knows to highlight the contiguous range above or to the left. I want to create a macro button for Subtotal that does the same thing, without the subtotal groupings. How can I make the...

Hi, Not much experience in vba. My script ends by copying a filtered range and then pasting the (special paste values) further down the page. When the script ends the pasted range is still selected. I want to continue my script by adding a column of analysis to the right of this pasted...

Hello, I've been working on a macro that will create a meeting maker from a roster in excel 2010. I have a workbook where each sheet is a roster for training that multiple people use, for this reason and for learning reasons I'm doing this in VBA. In my roster I have several columns for...