Hello
I have a sheet that contains formulas and is protected (password "43215")
I need a VBA code so that the user can select one or several rows , Insert them down WITH The formulas
Can anyone help ?
Thanks
Hello
I have a sheet that contains formulas and is protected (password "43215")
I need a VBA code so that the user can select one or several rows , Insert them down WITH The formulas
Can anyone help ?
Thanks
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi
Thanks for replying
the above macro is giving me an error very often ( attached) error 1.png ( Automation error -the object invoked has disconnected from its clients )
Furthermore , when the macro runs it does not do exactly what I need
Lets say my Excel sheet (PROTECTED) has a table with 3 rows containing formulas ,like this
AAAAA
BBBBB
CCCCC
What I want is that when I select rows "A" and "B" and run the macro to have the following :
AAAAA
BBBBB
AAAAA
BBBBB
CCCCC
However, What I Am getting with the macro provided by Sixth sense is the following:
AAAAA
AAAAA
AAAAA
AAAAA
AAAAA
... That's not exactly what I need
Please help
Thanks a lot
Anyone ? Please help
bumpity bumpito bumpita
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Ok
Please find attached the Sample work book (Test_Sheet) . The password for the excel sheet is "1234"
Also please find screenshots of what I want the macro to do
The "Before" screenshot is the sheet before I run the macro .
The "After" screenshot is the expected result
The VBA code should allow the user to select one or several rows , Insert them down WITH The formulas
At the moment I have a Code ( linked to button "insert selection" ) , but its making the excel crash sometimes and give the following error
Run-time error ' -21474178848 (80010108)'Please Login or Register to view this content.
Method 'Insert' of object 'Range' failed
Please if someone could just tell me why the excel crashes , or give me a code that would work without crashing excel I would be much obliged
Are the Pictures "before" and "after" appearing ? Trying again
BEFORE.jpgAFTER.jpg
By the way the rows I want to insert down in the test sheet are rows 11,12,13 and 14 ( I select all 4 of these rows then run the macro and they are inserted down )
Last edited by Sardokar21; 01-27-2015 at 04:01 AM.
Awwww ... come on ... no one ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks