increment numbers

If possible, I'd like to have Excel insert a number that increments by one in the first column of every new row in a given table like so: GID FN LN 800 John Smith 801 Jill Rogers 802 Sam Spade 803 Sally Spade 804 Bill Bayes but that will also allow for manual...

Hello everyone, this is my first post on here and I'm totally new to Word, Macros, and Visual Basic programming, so apologies if I don't know the lingo, or if you spot me doing anything completely noobish. I do however have some experience with PHP programming and have spotted a few...

Hello, I am new to VBA and have run into an issue with an array formula over 255 characters. The array formulas are different for each cell and are already present in each cell, so I would like to loop through a range, increment a number by 1, and then apply the cntrl+shift+enter to each cell...

I am attempting to open about 650 excel files in a folder and I want to use a for loop to do it. I have tried just throwing a for loop at the begging of my code that increments to 650 and the rest of my workbook manipulation after that. However whenever I go to open a workbook with the...

Looking to automate daily worksheets by having the date/time columns automatically fill in based on drop downs for Month and Year and while the Day is retrieved from sheet names (numbers 01 through 31). Although I think I have the date part working, I am trying to get the hour as well. When...