developer

Hello, My excel is a master document that pulls in data from different excel sheets in different departments, each of which are all updated daily. I need to save the "master" excel once a week into a different excel with all the values pasted. This creates a weekly snapshot of the data as it is...

I have been using a spreadsheet that friend made a few years ago that has a macro embedded in it. This past week, Excel has updated to a newer version and now I am receiving a Run-Time error message and am unable to run the macro. Here is the Runtime Error: When I click on "Debug"...

Hello, I'm really new to the developer side of Excel and I wish to solve a problem with macros or VBA. I have a table of items placed in colums (there are around 50 columns). In this table i scan a DMC (data matrix code) and place it in cell that it needs to be in. I'm kinda getting tired of...

Hi everyone, I currently have the 2 formulas below Bulk <p> </p> each paragraph: Sub aTest() Dim rCell As Range, spl As Variant, i As Long For Each rCell In Selection spl = Split(rCell, Chr(10)) For i = LBound(spl) To UBound(spl) If spl(i) <> "" Then...

Hi, I have this code which helps me in saving data for two cells in different sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("M2").Address Then Dim intLastRow As Long intLastRow = Sheet2.Cells(Sheet2.Rows.Count, "A").End(xlUp).Row Sheet2.Cells(intLastRow...

Hi, I have created a custom budget sheet that we will be using in our organisation and have hit a road block with what I would like it to do next, and hope that someone may be able to offer some help. I have scoured the internet and tried to work this out but my knowledge is limited! Thank you...

Hi All, Just curious is there a difference in saving in Developer mode to saving in Workbook mode? The reason I ask is I was working on a (for me) complex VBA script and would meticulously click the "Save" button in Developer EVERY single time I made a change. I had to run an OS update (on my...

I added a button to my worksheet from the Developer Tab Now I can't delete the button. Every time I try to right-click the button, I get no response. I'm in Design Mode (on the developer tab). If I left click the button the macro runs and I get the error "Unable to get the Buttons property of...

hi , I have number in cell from C6 to C2500. something like 255, 240.50, 266.67, 312.25, 20.10 etc. I had insert spin tool from developer and i want to spin only this number in my A1 cell. so what i do ? this is image of my worksheet https://ibb.co/3r9pQCJ

Good Afternoon, I have an input box that shows a veryhidden sheet. I'm trying to use Cell B23 on Developer sheet as the password (so the password can be easily changed). This code worked perfectly when the password was just typed in the coding itself but now trying to reference the developer...

Iam unable to see the code in developer view.

How do I enable the Developer Tab in Excel?

I've just moved from a Windows PC to Apple MacBook Pro. Love the Mac once I got myself familiarised with the new operating system etc.... Problem I have is with old Excel Flies I've previously created which use Combo Box for Dropdown menus created within Developer. The Developer Ribbon...

Hi, I have created an XML map to pull RSS feeds onto my spreadsheet. However, when I refresh the table, it overwrites the existing data. I don't want the older feeds to be overwritten. I would like to keep a track of all the feeds coming in over time. How do I avoid overwriting? I'm using...

Hello All, I am using OFFICE 2016 Professional. After running one macro, My Icons on Developer Tool Bar is greyed Out. I am not able to either edit / run any macros. Can anyone help in fixing the same. Regards Sudhakar R

Can anyone help me create a scroll area in excel 2011? I've been reading the steps, From the Developer tab, in the Control group click Properties Locate Scroll Area and enter the range you want to limit the worksheet to. Such as A1:Q30 However, in excel 2011 I do not see such button...

Hi, I have a macro which works fine. Then, I wanted to write another macro, so I clicked on Record Macro (in Code section of the Developer tab), gave it a name, stopped recording. The new macro name appears as expected in the code section of the Developer tab under Macros. HOWEVER, when I open...

Hi, Can anyone advise whether we can bring the calendar using Activexcontrol from the developer in excel.

Hey everyone, I'm new to excel and new to this forum, I have been asked to create a scroll bar and to do so you need to use the developer tab. I figure out how to put the tab on my ribbon but once I did that it appears to be missing some things inside the tab. Groups such as code, add-ins...

Strange one... I have a macro that returns data values in a matrix table format. When I run the macro from the Developer ribbon (Developer - Macros - macro_name - Run) it returns the values I need. When I run the macro from a button it returns lower values. The macro looks at two columns and...