if i am at c15 then when i run a macro i need to insert a blank coloumn in a16:iv16
need a macro
if i am at F25 then when i run a macro i need to insert a blank coloumn in A26: IV26
means just insert a blank coloumn at below
if i am at c15 then when i run a macro i need to insert a blank coloumn in a16:iv16
need a macro
if i am at F25 then when i run a macro i need to insert a blank coloumn in A26: IV26
means just insert a blank coloumn at below
It is not seems to be a column when you are referring to a range A26: IV26. Please confirm whether Column Needs to be inserted or cells? If so confirm how to move the current cells (Right or Down)?
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 anilg0001. i'm assuming it's rows you are referring to? is your Developer tab on? click on the windows icon -> Excel options -> Show Developer tab in the Ribbon. you can simply record this process.
1. click on C15.
2. Start recording by going to Developer tab -> Record Macro
3. Name it & click ok
4. in the Developer tab, ensure "Use Relative References is clicked (turns orange when clicked).
5. click on row 16 & right-click -> Insert Row
6. Stop macro by going to Developer tab -> Stop Recording
if you need the codes, it's simply:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
nothing more
if my ActiveCell.Row = 133
i need a blank coloumn below the active cell (means a blank row (A:IV) at 134 row
u got it
thank u mr.benishiryo
the below code shows error how can i correct it
i need to copy a particular cell and then insert below a row and paste that in B range
Please Login or Register to view this content.
Error Part
Replace it withPlease Login or Register to view this content.
OrPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi, anilg0001,
this is just one value - why Copy&Paste?
You should revise the thread title as you wanted to insert Columns but insert a row by now.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks