current region

Here below is the code to create a draft email from excel, the current region is correctly selected but it doesn't show in email body correctly, it only shows a word "True", please see attached 2 pics. Please help as I have googled for days and cannot sort out the problem, thank you so much...

Hi there! I'm currently getting run-time error 1004: "Unable to get the CurrentRegion property of the Range class" within following subroutine: Sub clearData() Dim modDataRng As Range Set modDataRng = Sheet2.Range("B4:B7") If WorksheetFunction.CountA(modDataRng) > 0 Then...

Hi guys, I don't know why I can't select the current region. My data range is ("B6:D20") I select the cell "B6" then I go to "Find and Select" then I select "Current region" I press ok The result of that is that the whole sheet is highlighted I wonder if anyone know why this is happening...

Hi Forum, example: <tbody> a b c d e 1 2 5 6 7 8 sum (e5:e8) </tbody> suppose above is the data on sheet 1 I want to find out sum of last current region of column "E" starting from "5" to "8" since I am new to...

Hello, I want to highlight the subtotal and total rows within a number of tables using VBA. Each table has different numbers of rows and columns. For example: In table 1, the subtotal rows are: B23:J23, B35:J35, B39:J39, B44:J44, B51:J51. The total row is B52:J52. In table 2, the subtotal...

I have code to minus header row but I also need to select current region minus header row and last column. Can anyone help. Here is my current code Selection.CurrentRegion.Select Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select Thanks!!

Hi all, I am looking for a general theory as to go about using Vlookups with "CurrentRegion" arrays. This is because the lookup table is never strictly defined. That is, 1) The actual lookup table will be the current region of .. say "A37". 2) Have the col_index_number value refer to a...

Hi, Could anyone teach me how to select multiple columns in CurrentRegion property so that I can create a Bar chart based on it Below are my progress so far.. however it doesn't work Public Function FourthTable() Dim Source As Workbook Dim Search As Range Dim CR As Range...

Hi, I am using RowCount = Worksheets("Input").Range("A1").CurrentRegion.Rows.Count and entering data from form as follow; ith Worksheets("Input").Range("A1") .Offset(RowCount, 0).Value = Me.Supplier.Value .Offset(RowCount, 1).Value = Me.GLCode.Value .Offset(RowCount...

Dear All, I am trying to set the print area in a macro to the current region based on cell A3. I have the following code: ActiveSheet.PageSetup.PrintArea = Range("a3").CurrentRegion I get the error: Run-time error '1004': The text you entered is not a valid reference or defined...

Hello All, I would like a macro that copies the current region but doesn't include the header row. Thanks