range activation

I have two worksheets, "Items" and "Originals". I run a UserForm from "Items". I want to be able to: Find the current row I am on. Go to that same row on "Originals". Copy the row, and paste the data back onto the same row in "Items". I have come up with this but it just tells me what row...

I receive a report that has row 1 headings that include "date" with cell text strings of "yyyy-mm-dd." What I produce is a series of date based windows. So the need is to look in row 1 for all occurrences of the string "date", select the column, find "-" & replace with "/" then format the...

ActiveSheet.Range("E2").Select ActiveCell.Range("E2").Select ActiveWindow.Range("E2").Select How the above mentioned syntax in VBA actually performs as i tried all gives the same result. :) Thanks in Advance.

Hi there! I'm making a subroutine that uses a cell reference as an input (the active cell). My question is: If I pass a range as "ByRef NAME As Variant", does "NAME" have a worksheet "attached" to it, or is it just a location on the active worksheet? For instance: Sub Add(ByRef NAME As...

Hello, I'm new to VBA and have been developing a macro for a database. I've completed about 95% of it and it all works successfully. However, I'm having trouble with the last thing I want it to do, which is replacing data. So here is the situation: I have a form and a 'master' sheet. The...

I want to convert an Excel Table into a range, but the option is grayed out no matter what cell that I click in. Under the table tools, none of the options seem to be available - they are all grayed out as well Columns B-F are hidden and I am unable to unhide them Column Headers A, U and Z are...

I have an ODBC Query that pulls GL activity from our ERP system into Excel. The size of this data increases the number of rows every month. In columns to the right of this data, I copy down some vlookup and other formulas that I use to organize the raw data and do sumifs on on other pages to...

Hello people! I have the following piece of code, that gets error 400: public sub TestMe Dim range_for_analysis As Range 'tbl_master.Activate Set range_for_analysis = tbl_master.Range(Cells(current_row, STARTING_FROM_COLUMN), Cells(current_row, calendar_cols + COLUMNS_NOT_TOUCHED))...