rangeselection

Hi Team, Can somebody help to fix the issue. I am trying to copy data from AQ column to AP column with visible cells using cell reference. however it is pasting only "RC[1]" for all the cells of AP Column. Range("$A$1:$BS$20467").AutoFilter Field:=40, Criteria1:="EnterpriseSolutions"...

I created an excel workbook which contains 2 sheet. In one sheet there is data. From the 1 sheet a bill format is made by giving v lookup. I went for a macro for printing the bills whereas the bill created is replacing the earlier. This is the code. Sub PrintBill2() ' ' PrintBill2 Macro ' '...

This was made in Excel 2013 for windows and I'm still using that version of excel. I've had zero issues with this macro, then all of a sudden this morning I'm getting this error. I've been to multiple sites and tried various things, but nothing seems to fix it. Any thoughts? I do get the...

Ok, I recorded a macro to sort a spreadsheet the way I need. That's the first code posted below. The issue is, I have 5 sheets that I want sorted the same way. I took a stab at coding for this, leveraging some other code that I have (2nd code set), but I'm getting an "Unable to Find Sort...

Hi All, I have been amending some code which filters data from various tabs of a master spreadsheet, and copies and pastes these tabs into a new spreadsheet per department. The code I have (admittedly it was existing code which I have been able to manipulate to suit my needs) currently copies...

Hi Peers, Can i get your advice to see if there is a quicker way of deleting rows than the piece of code that i wrote.

Hey guys, Im trying to build a list of imported bills into a new workbook. This workbook will become increasingly larger and large of a list as we import new bills each day. I need to to select from the active workbook and select the active rows and copy and paste into the same workbook each...

Hi, our system generates reports as CSV files. I have a macro in a spreadsheet to open these, copy them and paste them into this sheet, (it then goes on and does other stuff.) The macro just stops after opening the first CSV file, but if i step through, it works fine. It even works right to...

Okay, so this one is driving me batty. Very simple, I am pasting data from one workbook to another. I am doing this several times as I have to pull the data under certain assigned accounts. I receive the above error for this line of code, Selection.PasteSpecial Paste:=xlPasteValues. I have read...

Ok so I am recording a Macro (actually not the whole thing, trying to learn to write). My issues is I unhide my udpate sheet "Forecast Update", open "H:\FORECASTING GROUP\Demand Planning\Forecast Reviews\2017 Q4 Review.xlsx" and want to copy and paste from "H:\FORECASTING GROUP\Demand...

To, All experts, pls provide me some professional code for below line of code..So i can learn the new.. Windows("Book1.xlsm").Activate Sheets("sheet1").Select Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy...

Hi, I have a worksheet which I protect with these settings. Select unlocked cells Use auto filter Use pivot table and pivot chart Once set, all works well, however.... I have a macro I use which expands or retracts the row heights in my table. When I run this I use this code. Sub...

Sub sumcopy() 'April/2017 Dim first_day, lasy_day, month, year As Integer Dim mmonth As String Dim source_file As String month = InputBox("Please enter the Month", "TCU//QNB Finansbank") year = Worksheets("Macro").Cells(6, 2) 'Hangi ay hangi sayfada onu buluyoruz. If...

Hi Everybody, I would like to copy an entire row which is -1 next to an active cell from BI ( so i want to copy content from A to BH. I was able to select and copy the rows until non blank row however if the row contains blank cell then the VBA search data which above it until it not find. I...

Hello, I inherited an Excel file that has a macro. Basically, you are supposed to click a button and it updates from two different files saved in a network drive. The updating works fine, however it is supposed to set a print area and perform a custom sort. The issue I have been asked to fix is...

Private Sub CommandButton1_Click() Sheets("Results").Range("E16").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.ClearContents End Sub Not sure what I'm doing wrong here, but all I want this to do is go to...

Hi there, I am new to VBA and have used the macro recorder to record the process I am trying to achieve. The issue I am having is that when the length of the column changes my Macro is stuck to the same column length (range) I used for the original graph on the Macro Recorder. Effectively I...

I am on Excel 2010 version. How do you sort on 2 columns? The first sort will be by Column B, Ascending, then by Column G, Descending. Below is the code I have. Range("A3").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Sort...