xltoright

  1. B

    use next available cell in row (xltoright)

    i need help getting this code to paste in next empty cell to right. the code only paste in column B. i need-if column B is not blank then use next cell to right. Dim ThisCell1 As Range Dim ThisCell2 As Range Application.ScreenUpdating = False For Each ThisCell1 In...
  2. H

    xlToRight Issue

    Hi, I'm using the following code to find the end of a range but the problem I'm having is that range (the xlToRight) can change. Is there a way to instead have this select all the way to the right until it runs into a certain value? For example, if I have the word "END" in column T it would do...
  3. N

    Excel VBA - Alternative to Copy/Paste with xlToRight xlDown

    I am trying to simplify the VBA below as there's too many selects and with the array of data being copied from one sheet to the other as the sheets get larger in size, I want to reduce the overhead and increase the speed it executes. It currently works, but isn't the cleanest. The "TODAYS_DATA"...
  4. A

    VBA - Same formula in the same column but different rows

    Since my last column is not always absolute I use the xlToRight command to get to the correct cell. I am trying to do the same step for row 5-11,14-20 and 23-29. Currently I have something like this: Range("C5").End(xlToRight).Formula = Range("C5") - Range("C5").End(xlToRight).Offset(0, -2)...
  5. S

    Update Code for specific entity deposits

    All deposits get posted to one account, which we then have to transfer amounts to the entity it belongs to. * In column I , I have a deposit from one of my entities in Columns J:CT.* To get to the entity that the deposit belongs to I do an XLtoRight and grab whatever is in Row 2 above that...
  6. O

    Need to do an "xlToRight"-type move in Excel to move right more than one column.

    Hi! This is my first post, and I haven't been able to find the solution to my exact problem, even though I've found things that seemed similar but didn't work in my case. I have a very nice piece of VBA that I got from Microsoft Answers: Loop thru one column, find specific text, shift right one...
  7. P

    creating automated income statement, want to add dynamic monthly column to AVERAGE and SUM

    Hi VBA masters, I'm creating an automated daily income statement with currency rates, cash balances, expenses, etc. I would like to add a monthly column that's dynamic and uses VBA's ".Formula" tool to add functions and perform calculations on the daily values. I'm having trouble using the...
  8. B

    Autofill XltoLeft

    Hi, Need some help with either an XltoLeft or XltoRight Autofill I have a userform where the user selects their shift start time and then their shift end time both from inbuilt combobox to ensure uniformity. For example: Shift Start Time 9 Shift End Time 17 On pressing submit, in this...
  9. S

    Lookup the last value in a range and selecting the date

    Hello, I have a worksheet that has ranges of string values that contain a date within the first 5 characters. I am able to locate the date from the cell: =MID(R10,1,5) But I am now having difficulty locating the last cell in a general range with value. I have found macros to assist...
  10. L

    xltoright question

    Just a quick one. How can I work with xltoright to fill a space beneath a row of data? I have a column of formulas that I have copied and I need to just spread it as far to the right as the row of data directly above it. Here's what I use to copy: Selection.Copy Range(Selection...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top