cut

Hi I am trying to cut and paste a range. The code below is giving me out of range error mesage. it opens the second file but wont do the cut. Thank you so much Sub cutcells() Dim x As String x = InputBox("enter workbooks name") Workbooks.Open Filename:=x...

Lets try this again. I tried posting this once and the site kicked me out without posting what I'd typed. Not sure why. This will be more brief so if more info is needed please reply and I'll answer everything. My goal - to use SUMIFS - or another formula if I'm using it wrong - to only pull...

Hi Everyone. So far my macro does all that I want except an error at the end of the macro ,which is my lack of understanding of how to end the macro when it's finished. The error is run time 1004. What the macro does is search for a piece of Txt using Find, it then cuts the data pastes it into...

Hi What is the short cut of excel speak command. Many websites (like the one below) list excel short cut but none talking about speak cells. Any idea would be appreciated very much. https://yodalearning.com/tutorials/ms-excel-shortcut-keys-for-beginner/

If I had a nickel (remember those?) for EVERY TIME I got a R/T error 1004 using the VBA Copy/Cut Paste procedure I could retire in the Cayman Islands tomorrow I'd love to find a teaching source that would clear up everything I seem to do to get these probs... Why, if you can tell, is it that...

First, thanks to mole999 for the help with the first phase of this. I thought I'd be able to use the principles to implement the next phase, but my limited VBA knowledge and research hasn't been enough. I am trying to have cut, copy, and paste inactive for most users, but if the user enters a...

Hey Guys, I'm trying to hide a text box and make it reappear using a checkbox. Once hidden or cut and pasted I need to then hide the rows where the text box once was. I have read online you can't hide and unhide a text box using VBA... so instead I have chosen to Cut the group of text boxes...

Hello all. Having this issue now. I was using a standard "Lastrow" declaration but it was putting to the bottom of the table range. Instead I need "Lastrow" to hold the bottom of the active cells in data, and then paste the cut line below it so it appends the table. Set F =...

Hello, I'm attempting to find a word, highlight that cell and all the cells to the right of it. Cut that range and then paste it over 3 cells to the right. Once I get the cut and paste working, I'll need to work on the loop to look at the entire column. I think I'm close but I'm getting a...

My code keeps failing at this line and I am banging my head against a brick wall! :banghead: Sheets("Diagrams").Range(Cells(LastCR, 1), Cells(LastEnd, 6)).Cut Destination:=Sheets("New Diagram") For the first range to be cut, LastCR=6862 and LastEnd=6807. How do I cut this range to the...

Hi I've written some VBA code which selects then deletes certain columns. I then want to cut two columns and paste them at the end of the data. I've written the code below, but Excel doesn't like the last line, where I've selected column U and attempted to paste the columns I'd just cut...

hi all, kindly anybody tell me short cut to find out desired output if possible. i have a record on station wise separate sheet. 50 sheets station wise. i apply: =VLOOKUP(F2,A2:D7,3,0)+VLOOKUP(F2,Sheet2!A2:D7,3,0)+++++ this is too lengthy. is there any short cut to find Vlookup countif, SUMIF...

Hi ya, I have an excel sheet with three sheets. First sheet has certain information as follows. <tbody> S.No Name Job 1 A X 2 B X1 3 C X2 4 D X3 </tbody> In second sheet, I sometimes cut and paste entire rows from first sheet. So as an example, my second sheet could be. <tbody>...

Hello, Im trying to run a macro that will make multiple sheets. I want it to cut any cell that is say "blue" and anything beneath it till another blue cell into another sheet based on the text in the first blue cell. Any ideas?

Hi is there a code that will cut and paste in a range if cell D is not blank and paste in cell B? Thank you

How to cut list into pieces that are marked by / ? so that 1/2/3/4 would become 1/ 2/ 3/ 4/ By doing a macro? so that it would cut after / and paste into new row? and repeat until the last / ? Thankyou :rolleyes:

Set Fnd = Range("6:6").Find("%", , , xlWhole, , , False, , False) If Not Fnd Is Nothing Then Intersect(Range("M7:M5000"), Fnd.EntireColumn).Cut Range("Q7").PasteSpecial Paste:=xlPasteValues End If I wish to find "%", then cut and paste special values, but as usual, It tells me a...

I am reporting on supplier rejects over a 3 months period. I have a list of events with supplier account numbers in column F. I want to strip out the unique occurrences and rank them into a top 10. this is my working formula as an array. (probably over complicated but it get the job done)...

Is there any way to re-situate the grand total column on a pivot table. One of the higher-ups here wants the total column to the left of the data. I know I can cut and paste special and move the column but I was looking for an easier solution to populate data going forward each month and...

Hey everyone. I have been working two days on trying to figure this out and have made no progress. I've read the multiple posts and numerous other websites, but cannot get it to work. So below I will explain what I have. Dim lastFriday, Sunday, Monday as date 6 columns: actual release, actual...