.select

Hello, I am trying to jump columns in excel from a cell, could anyone help? I'm trying through For sub test () For i = 1 To 5 Cells (i) .Select Next i End Sub What I need is to start in cell A, then jump every 10 columns until it's over.

I am trying to crate an inventory tracking spreadsheet. I have made a button that moves entered information to another sheet. The button takes the information in cells A6:F:6 individually and applies the information entered to a list of parts on another page. The code I am using to do this is...

I built a macro that copies portions of pivot tables and charts and then pastes these onto a tab as pictures one below the other. At the end of the macro the worksheet with all the pictures is copied to the clipboard and then is easily pasted into the body of an email to be sent out. The...

Hi team, I've gotten into the habit of creating code like so, which requires the .select behaviour. Which is all well and good but I now want to not have to make tabs visible due to the limitations of my code. How would you suggest I get the same output, without the use of .select which...

Hey I got a weird Problem with my Code (Clean Sheets Cells) I have Picture on my sheets to press on and Macro Running as it should everything in the Code Works ok BUT BUT when the code is running from sheets 2 Clean Specific cells and then Jump on to sheets 1 and Clean specific cells as it...

I am trying to create a macro to enter a formula for the average of all the cells I have selected in the cell immediately below the selected range. I can not seem to find the correct syntax. Here is the code I have thus far. Sub Test()Dim x As Range, y As Range Set x = Selection With...

Hi, can anyone help? I want to remove .Select from the Sort to make things run more smoothly .Range("A2:K" & lRowA).Select .Range(Selection, Selection.End(xlDown)).Select ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear...

Is there a way to offeset the cell selection without using .select? I have a macro that requires a lot of cell offsetting as it runs, but the .select commands are slowing things down to much. I've read a lot about ways to remove .select, but with all the copying and pasting this macro does I...

Hello Can anyone please tell what is wrong with my code. When I run this Sub CalcWriteMisc() everything works perfectly. Sub CalcWriteMisc() 'Calculates and writes misc. items to MiscItemsDB Dim ws2 As Worksheet: Set ws2 = ThisWorkbook.Sheets("DataEntryItemsDB") Dim ws3 As...

Hi this works for me fine. I know I shouldn't be using .Select and a lot of other stuff in here. I tried cleaning it up not using .select and active paste, but when I do so the code doesn't run the same. Some always gets placed wrong. I can definitely use a clean and efficient vba code here and...

Dear friends, I have the following issue with a macro that collates near 600 tables (5x13) and paste them in different sheets in order. In other words, the macro builds a DB with hundreds of tables distributed in several sheets. Because it needs to copy and paste so many cells the macro became...

Hello, I would like to select every other (or ever third/fourth) cell in a row using STEP (or a better method if there is one). Every other cell needs to be selected at the same time (similar to holding ctrl and clicking on multiple cells). My end goal is to create a line graph (without...

Hi all, I am a self taught VB programmer that is new to this forum so bear with me if my question seems simple, but it should be easy to answer. I have been creating a macro in file called "converter.xlsm" that converts a database file (example: data.csv) to one that I can input into an assembly...

Hi VBA people, I know that many advanced VBA users advocate getting away from using selects. It seems there are many work arounds. However, I have a project where a .select might be best. I would like to get the user community's feedback on how optimize and improve this process: ' Copy the...

I've recently received an upgraded computer at work. Yay! However, it's running Windows 7 and several of my applications are not working properly anymore. resultsSheet.Rows("11:" & maxrow).Select is the statement that fails. I need to select all of the data from row 11 down and create a...

Hi everyone, As I learn more, I am trying to streamline some pieces of code. I am currently working on .Select code. I have this extract of code: (let me know if I'm better off posting the whole code) Note: the red comments are ones I have added into the post...