subscript error

I am have some trouble with selecting ranges. its a bit of a scenario- I have one Master workbook with multiple sheets -I am trying to import other workbooks' data into the master sheet in its respective sheet --I have multiple sub workbooks or sub Master workbooks with identical sheets...

Hi, I'm currently trying to write a VBA code, it looks like this: Dim currentTopPos1 As Long Private Sub cmdSaveData1_Click() Dim settings As Variant Dim info() As String Dim index As Long With Sheets(sheet_settings1) ReDim info(1 To getLR1(.Name, "A") - 1)...

Hello, So, I know this is prob really simple to a lot of you, and I wish I had your mindset, but I am just not grasping this concept :( Everytime I try to work with these I hit type mismatch or subscript mismatch errors... then on the few random occasions I change something and avoid all of...

So I am reasonably new to VBA and am having trouble with this error. I am trying to set up a macro button that will allow me to import a sheet of data from two separate files whos location is specified in the main workbook. The main workbook has the following tabs: Version, Start, Summary...

Hi All, I am getting he Subscript out of range error when trying to run this macro. I have the macro on a macro workbook and I am referencing another spreadsheet. any help would be appreciated. Sub Dater() Static Count As Integer Dim Wb As Workbook Dim Ws As Worksheet Dim...